Viewing 15 posts - 91 through 105 (of 284 total)
SQLPain (12/29/2015)
Is it because of the performance issue I shouldn't be using it in the where clause:
WHERE CONVERT(varchar(10), a.DateAppReceived, 101) = CONVERT(varchar(10), GETDATE(), 101)this actually did the job for me.
Your...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 29, 2015 at 10:25 am
SQLPain (12/29/2015)
WHERE (a.DateAppReceived Between GETDATE()-1 AND GETDATE())
WHERE (a.DateAppReceived = CONVERT(varchar(10),(DATEADD(dd, datediff(dd,...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 29, 2015 at 10:17 am
What is the data type of a.DateAppReceived?
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 29, 2015 at 9:12 am
mr.databases (12/14/2015)
CASE WHEN det_dte IS NULL THEN CAST({ fn NOW() } - rec_dte AS int) ELSE CAST(det_dte - rec_dte AS int) END
rec_dte and det_dte are both data type datetime.
The...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 14, 2015 at 4:47 pm
This is query is similar to what you have except that it has 1 less table scan because there is 1 less inner join, which made it about 45ish% faster....
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 7, 2015 at 4:14 pm
You can try changing the column to an identity column under Design in SMS. If that works, you may have to seed the table with the correct next identity...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 16, 2015 at 4:51 pm
This should do it:
with cte as
(
Select hierarchyid, hierarchyval,
row_number() over(Partition by hierarchyval order by hierarchyid) RowNum
from #test
)
select *...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2015 at 7:00 pm
brianconner (10/13/2015)
Thank you so much that worked like a charm...
Glad it worked for you.
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 13, 2015 at 6:56 pm
LinksUp (10/13/2015)
Since you posted in a 2014 forum, here is a solution that will work in any version after 2012.
Just for the fun, here is a version that will work...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 13, 2015 at 6:52 pm
Since you posted in a 2014 forum, here is a solution that will work in any version after 2012.
Please read the link in my signature line and note how the...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 13, 2015 at 6:34 pm
Luis Cazares (9/24/2015)
Or avoid the JOINs.
😎
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 24, 2015 at 2:03 pm
jkramprakash (9/24/2015)
i want to delete this three records.
but in last record for id =35 and...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 24, 2015 at 11:49 am
Paul Munter (9/22/2015)
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 22, 2015 at 8:52 pm
montserrat.deza (9/18/2015)
I need to display in my query the values are coming from Order_1, means AttributreValues coming from AttibuteNumbers: 2001,2002,2003...and Order_2 the same thing.
Is this what you are looking for?
declare...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 18, 2015 at 9:42 pm
hegdesuchi (9/16/2015)
another scenario is,
Scenario:
ODS table :
CustomerID column1column2column3
1abcabcabc
2xyz xyz xyz
Dbo table:
CustomerID column1column2column3 date
1abcabcabc 1/1/1900
2xyz xyz xyz 1/1/1900
Now If I get any new record for customerID "1" in ODS table,...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 16, 2015 at 4:31 pm
Viewing 15 posts - 91 through 105 (of 284 total)