Viewing 15 posts - 33,151 through 33,165 (of 59,102 total)
hxkresl (7/22/2011)
TBLANIMAL (as T)
animal varchar(40)
haveit bit
name varchar(30)
ANIMAL (as A)
animal varchar(40)
haveit bit
name varchar(30) Primary Key
I am merging on T.animal = A.animal. The source table (T) has...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 2:03 pm
Not quite what I had in mind. You put the double quotes on the wrong side of the single quotes. I believe you want to end up with...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 1:56 pm
{sorry, duplicate post removed}
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 1:52 pm
CELKO (7/23/2011)
Create a report period table and join to it.
CREATE TABLE ReportTimeslots
(range_name CHAR(18) NOT NULL...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 1:48 pm
Having conducted many interviews over time, I've found that people frequently misclassify themselves. I know many Developers (for example) that think they're Level 5 Client/Server Developers who should be...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 1:39 pm
MuchLearnSoLittleTime (7/22/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 1:16 pm
Is it actually necesary to keep the data "online"? Or, can you get away with "offline but available"?
SQL Server can load information into a work table very, very quickly...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 1:13 pm
gracebite (7/22/2011)
Hi,how to [font="Arial Black"]calculate distance (in meters/KMs) between 2 lat/long [/font]as Cartesian product in 2 tables
Thanks
Grace
Actually, if you Google'd/Yahoo'd what I've highlighted in your original question above, you'd...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 1:06 pm
If possible not by stored procedure.
Why not? Hopefully, you're not making the mistake of using embedded code in a GUI or SSIS or...
I'm not sure why you'd do such...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 12:57 pm
tt-615680 (7/23/2011)
We are having a yearly mains supply check, therefore I would need to check for the availability and the health of the SQL Server. I would like to...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 12:46 pm
Encapsulating the entire path (drive, path, filename) in double quotes should do the trick.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 12:38 pm
opc.three (7/22/2011)
I did some quick testing and inserting 400,000 rows into the table variable was about 20% faster that inserting the same rows into a traditional temp table.
Heh... you know...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 12:34 pm
Ninja's_RGR'us (7/22/2011)
Jeff Moden (7/22/2011)
Gah... I've got to learn to read the rest of the posts first. Tow other folks basically said the same thing.
I would point out the obvious...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 12:21 pm
According to the links SwePeso provided, you already received an answer a half hour after you posted. It would be the right thing to do if you let people...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 10:26 am
Gah... I've got to learn to read the rest of the posts first. Tow other folks basically said the same thing.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 22, 2011 at 4:19 pm
Viewing 15 posts - 33,151 through 33,165 (of 59,102 total)