Viewing 15 posts - 32,596 through 32,610 (of 59,102 total)
I disagree. Using Temp Tables to "Divide'n'Conquer" is frequently much more efficient that using CTE's or derived tables to do a complicated task.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 1:38 am
karthikeyan-444867 (9/10/2011)
I have recently answered some questions under 'QOD' section. I saw the below one and it looks strange for me.
create table [VARRAY[]]]
(
eno int
)
When i execute the above code,...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 10, 2011 at 9:55 am
You might want to continue your good use of GOOGLE to search for those two terms. For example, you get some really great hits if you search for "backward...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 10, 2011 at 9:10 am
This will do it...
UPDATE Report
SET ShipID = itst.shipid ,
PassengerCount = itst.PassengerCount ,
...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 10, 2011 at 8:59 am
jared-709193 (9/10/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 10, 2011 at 8:46 am
They say a compliment is a good thing. Two by the same person on the same subject is a sure thing. Thanks, Olga. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2011 at 8:43 pm
Nomvula (9/9/2011)
thanks guys for all the responses really appreciate it and i managed to get it.
Considering that there were a couple of problems with some of the code on this...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2011 at 8:41 pm
You bet. C'mon back when you get some clarification on this. It's actually a fun problem. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2011 at 10:06 am
Just remember that in a SAN envirionment, separate drive letters don't necessarily equate to separate spindles. Check with the folks managing your hard disk storage space to make sure...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2011 at 9:40 am
sowmya.boodaderureddappa (9/9/2011)
We are using a convert function for date column in where condition and doing comparison. BUt its not working as it has to
( Report date >= Effective...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2011 at 1:33 am
sqlfriends (9/8/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2011 at 1:28 am
We were in a development cycle for a particular "screen". To make a much longer story shorter, the screen displayed certain aggregated data based on user selectable start date...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2011 at 1:24 am
YSLGuru (9/8/2011)
GilaMonster (9/8/2011)
The log file.
Thanks Gail and I woudl certainly do that first but the llg file already is on its own drive. I negelcted to say that in...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2011 at 1:10 am
sunny.tjk (9/8/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2011 at 1:06 am
notoriousdba (9/8/2011)
You're seeing the length in bytes. Each NVARCHAR character takes up two bytes of storage.
In SQL Server, do you know of a language or collation setting that would cause...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2011 at 1:02 am
Viewing 15 posts - 32,596 through 32,610 (of 59,102 total)