No announcements
Found 1026029 threads
-
0 Votes
Understanding the T SQL Queries
Great article http://rusanu.com/2013/08/01/understanding-how-sql-server-executes-a-query/ Best Regards,Uri Dimant SQL Server ...Answered | 1 Replies | 686 Views | Created by Hemadribabu - Monday, May 2, 2016 5:27 AM | Last reply by Uri Dimant - Monday, May 2, 2016 5:46 AM -
0 Votes
SQL Query
newTable; set @sql='select * into newTable from (' + @sql + ') s'; exec(@sql); select * from newTable;Answered | 10 Replies | 722 Views | Created by Tech Aspirant - Monday, December 7, 2015 11:36 AM | Last reply by Sam Zha - Wednesday, December 9, 2015 2:46 AM -
0 Votes
Parsing a SQL query
Hai Parsing a SQL query please send the code for query parsing.Answered | 17 Replies | 44141 Views | Created by david2929 - Wednesday, September 6, 2006 8:07 PM | Last reply by Tal Giladi - Thursday, September 2, 2010 10:41 AM -
0 Votes
SQL query
Create Table #Foo(ID int, Number int); Insert #Foo(ID, Number) Select 1,2 Union All Select 2,10 Union All Select 3,15; With cte As (Select ID, Number, Row_Number() ...Answered | 4 Replies | 3519 Views | Created by captainsina - Friday, May 21, 2010 2:19 AM | Last reply by Tom Cooper - Friday, May 21, 2010 2:56 AM -
0 Votes
Performance tuning a SQL query
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL ...Answered | 7 Replies | 2177 Views | Created by SQL Kitchen - Sunday, June 23, 2013 1:38 PM | Last reply by SQL Kitchen - Monday, June 24, 2013 2:20 PM -
0 Votes
sql query
SQL 2005 is sufficient to use FOR XML PATH, as cen be seen from the documentation: ...Answered | 6 Replies | 681 Views | Created by Lakshmi N - Friday, November 13, 2015 10:47 AM | Last reply by Olaf Doschke - Tuesday, November 17, 2015 3:48 PM -
0 Votes
SQL query
Please tell us what SQL product and release you are using.Answered | 3 Replies | 3872 Views | Created by Prabin Yovan - Saturday, June 18, 2011 11:50 AM | Last reply by --CELKO-- - Saturday, June 18, 2011 9:35 PM -
0 Votes
sql query needed
This link should get you started ...Answered | 3 Replies | 1253 Views | Created by skc_chat - Thursday, June 20, 2013 4:39 AM | Last reply by _AKS - Thursday, June 20, 2013 6:17 AM -
0 Votes
SQL queries
for basic understanding of SQL check this out http://www.w3schools.com/sql/default.asp Nothing is Permanent... even Knowledge....Answered | 2 Replies | 4187 Views | Created by jeromejp - Tuesday, July 26, 2011 2:42 PM | Last reply by Surendra Nath GM - Tuesday, July 26, 2011 5:59 PM -
0 Votes
sql query
DECLARE @query VARCHAR(5000) DECLARE @dept_name VARCHAR(2000) SELECT @dept_name = STUFF((SELECT DISTINCT '],[' + dname FROM department ORDER BY '],[' + name FOR XML ...Answered | 4 Replies | 921 Views | Created by SandeepTK - Thursday, August 22, 2013 10:32 AM | Last reply by anuragsh - Thursday, August 22, 2013 11:38 AM -
0 Votes
SQL Query
DECLARE @ProductList varchar(8000) SET @ProductList = STUFF((SELECT DISTINCT ',[' + Product + ']'FROM #temp ORDER BY ',[' + Product + ']' FOR XML PATH('')),1,1,'') SELECT ...Answered | 4 Replies | 702 Views | Created by Leo00 - Tuesday, November 3, 2015 8:45 PM | Last reply by Visakh16 - Wednesday, November 4, 2015 6:10 AM -
0 Votes
MDX queries to SQL
T-SQL queries tables/views under relational database.Answered | 2 Replies | 1134 Views | Created by Bharath_RAM - Monday, August 31, 2015 5:01 AM | Last reply by Priya.N - Tuesday, September 22, 2015 10:04 AM -
0 Votes
English Query on SQL Server
If it was setup wrong, it produced results based on the wrong underlying SQL queries.Answered | 2 Replies | 2557 Views | Created by pete1064 - Tuesday, July 15, 2014 11:30 PM | Last reply by Olaf Helper - Wednesday, July 16, 2014 4:45 AM -
0 Votes
Trouble with an sql azure query
I can't seem to find any examples of SQL azure queries anywhere!Answered | 7 Replies | 2364 Views | Created by Vamp10988 - Monday, October 17, 2011 2:21 AM | Last reply by darnold924 - Monday, October 17, 2011 9:03 PM -
0 Votes
Analyzing a Query in SQL Server
I've never used that Execution Plan before so just tried it out on one of the queries that's timing out.Answered | 3 Replies | 7031 Views | Created by rwerner - Tuesday, October 31, 2006 4:15 AM | Last reply by Jens K. Suessmeyer - - Tuesday, October 31, 2006 9:06 PM -
0 Votes
SQL Query
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/ http://beyondrelational.com/modules/2/blogs/88/posts/10186/sqlAnswered | 3 Replies | 990 Views | Created by Kumar SK - Monday, September 29, 2014 5:24 AM | Last reply by ryguy72 - Wednesday, October 8, 2014 3:51 PM -
2 Votes
SQL Query?
SELECT Cashbook.Des, Cashbook.Amnt, Account.aname, Account_1.aname FROM Account AS Account_1 INNER JOIN (Account INNER JOIN Cashbook ON Account.ID = Cashbook.Debit.Value) ON ...Answered | 10 Replies | 2334 Views | Created by prince_061 - Friday, July 20, 2012 3:50 PM | Last reply by KCDW - Sunday, July 22, 2012 12:41 AM -
0 Votes
SQL to LINQ query no result
Hi, Sam is right, When you trim the time part, your query won't return results because you are comparing a date only field to datetime.Answered | 3 Replies | 1190 Views | Created by rebmaamberrebmaamber - Monday, June 27, 2016 6:35 AM | Last reply by Mahmoud Tolba - Monday, June 27, 2016 11:12 AM -
1 Votes
Sql Query
CREATE TABLE Students (student_id INTEGER NOT NULL PRIMARY KEY, student_name VARCHAR(35) NOT ...Answered | 4 Replies | 3083 Views | Created by Gangadhar Thumu - Wednesday, July 20, 2011 7:29 PM | Last reply by --CELKO-- - Thursday, July 21, 2011 12:04 AM -
3 Votes
sql query
The following article also deals with object definition in SQL Server ...Answered | 6 Replies | 2819 Views | Created by jatashankar patel - Monday, December 26, 2011 9:02 AM | Last reply by Kalman Toth - Saturday, December 31, 2011 12:32 PM
No announcements