No announcements
Found 1523670 threads
-
1 VotesT-SQL query for getting the employee name based on the request status
That will help us to give you correct query.Answered | 5 Replies | 648 Views | Created by sapwebintelligence - Wednesday, December 21, 2016 10:30 PM | Last reply by --CELKO-- - Thursday, December 22, 2016 7:48 PM
-
1 Votes
T-SQL query as XML
VARCHAR(20), column3 VARCHAR(20) ) INSERT INTO #tmp VALUES ( 'data1', 'data2', 'data3' ) INSERT INTO #tmp VALUES ( 'data11', 'data21', 'data31' ) -- FOR ...Answered | 5 Replies | 8540 Views | Created by Kirizzle - Wednesday, February 2, 2011 12:45 PM | Last reply by Naomi N - Tuesday, February 8, 2011 2:14 AM -
2 Votes
T-SQL Query Help
You never came back with aresponse on the other threadAnswered | 4 Replies | 1362 Views | Created by Aminesh - Tuesday, November 18, 2014 8:48 AM | Last reply by SaravanaC - Tuesday, November 18, 2014 9:39 AM -
0 Votes
Enhancment T-SQL query
There are very less chances that SQL can miss this plan but if it does than I recommend you to use below precautions if you are planning to keep this inside stored ...Answered | 3 Replies | 1140 Views | Created by SQL Kitchen - Thursday, April 16, 2015 1:05 PM | Last reply by Anuj Tripathi - Friday, April 17, 2015 3:55 PM -
0 Votes
Convert T-SQL query to DB2 query
What I can say is that if you had been converting to Oracle, you would have needed to add "FROM dual" to your query.Answered | 3 Replies | 2510 Views | Created by Magnus Baht - Friday, June 27, 2014 1:28 PM | Last reply by Erland Sommarskog - Friday, June 27, 2014 2:15 PM -
0 Votes
t sql query
Hi, Please provide the sample table and data so it can be easily design the query.Answered | 3 Replies | 3097 Views | Created by neophytenik - Monday, January 9, 2012 2:15 AM | Last reply by IT-Singh - Monday, January 9, 2012 12:16 PM -
0 Votes
SQL query to Pivot conversion in T-Sql
Since you need multiple values to pivot, it's easier to do this way: SELECT T.ProdNo, T.ResourceNumber, T.Answered | 7 Replies | 1479 Views | Created by Jeevan Dasari - Wednesday, July 8, 2020 5:39 AM | Last reply by Jeevan Dasari - Thursday, July 9, 2020 3:17 AM -
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 | 785 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
T-SQL Query
Code should be in Standard SQL as much as possible and not local dialect.Answered | 9 Replies | 4462 Views | Created by lata456 - Tuesday, January 11, 2011 9:00 PM | Last reply by NSMP - Tuesday, January 11, 2011 11:05 PM -
0 Votes
Help in T-SQL Query
Have you examined the limits of concatenating queries into huge T-SQL script strings?Answered | 11 Replies | 6303 Views | Created by XYZ001 - Saturday, May 15, 2010 10:45 PM | Last reply by Naomi N - Sunday, May 16, 2010 11:23 PM -
1 Votes
T SQL Query:
I have a problem with a sql request i didn't find the solution is there some one here to help me please Loubnas I'm glad you've ...Answered | 10 Replies | 3491 Views | Created by eva05 - Friday, February 24, 2012 10:05 PM | Last reply by Kalman Toth - Sunday, March 4, 2012 4:07 PM -
0 Votes
T sql query
.-]%', @DATA), 8000) + 'X')-1) ENDAfter the function was created I did use the code : with InPayIDs as ...Answered | 6 Replies | 4754 Views | Created by eva05 - Friday, June 24, 2011 8:15 PM | Last reply by Naomi N - Monday, June 27, 2011 3:30 PM -
1 Votes
T-SQL help on query
Hi Henrik, To get the expected output, you can try this way in SQL Server 2012 as well.Answered | 10 Replies | 1136 Views | Created by Henrik A F - Friday, March 18, 2016 8:55 AM | Last reply by Henrik A F - Thursday, April 7, 2016 6:32 PM -
1 Votes
SQL Query Question T-SQL
In the example below I want the query to return all 3 Red rows because one of the rows met condition = Bad.Answered | 6 Replies | 1127 Views | Created by laptop_01 - Friday, December 12, 2014 8:26 PM | Last reply by --CELKO-- - Saturday, December 13, 2014 1:52 AM -
1 Votes
t-sql query question
declare @t table ( Id int, Exclusion1 varchar(10), Exclusion2 varchar(10), Exclusion3 varchar(10) ) insert into ...Answered | 2 Replies | 4337 Views | Created by cocomckinley - Friday, January 8, 2010 5:37 PM | Last reply by ramireddy - Friday, January 8, 2010 5:51 PM -
0 Votes
Dynamic query in T SQL
But you can go for Parameterised Queries to overcome that.Answered | 6 Replies | 4101 Views | Created by Ajay Singh Rawat - Saturday, December 17, 2011 4:43 AM | Last reply by Erland Sommarskog - Saturday, December 17, 2011 4:11 PM -
0 Votes
Re: How to converting from PL/SQL query to T-SQL query
It will convert whole Oracle databases, or single queries or PL/SQL stored procedures.Answered | 5 Replies | 12974 Views | Created by sreenivas.bijje - Monday, June 24, 2013 10:03 AM | Last reply by Dan.Akelson - Monday, June 2, 2014 7:06 AM -
0 Votes
T-SQL Query Help.
Create Table #test (ID varchar(10),Name varchar(10),Date Date,Client1 varchar(10)) INSERT INTO #test VALUES (1,'Tony','01/01/2016','N1' ); INSERT INTO #test VALUES ...Answered | 4 Replies | 1090 Views | Created by TWoW2017 - Friday, May 19, 2017 4:25 AM | Last reply by TWoW2017 - Friday, May 19, 2017 2:55 PM -
0 Votes
Passing SQL query to a web request?
we thought if we fire sql query and can resultant data to be passed to data field and scripts to be executed.Answered | 4 Replies | 3982 Views | Created by kasireddy - Wednesday, January 28, 2009 8:44 AM | Last reply by kasireddy - Tuesday, February 3, 2009 12:44 PM -
0 Votes
T-sql Query Help
;with mycte as ( Select distinct id, name from Data ) ,mycte1 as (Select id, name, monthnumber from monthtable cross join mycte) Select m.id, m.name, isnull(d.charge, 0) charge, ...Answered | 4 Replies | 1151 Views | Created by Aminesh - Friday, April 18, 2014 10:38 AM | Last reply by Jingyang Li - Friday, April 18, 2014 12:32 PM - Items 1 to 20 of 1523670 Next ›
No announcements
