Viewing 15 posts - 2,701 through 2,715 (of 2,894 total)
I guess the next challenge would be to create the sp for users to formatt hard drive or/and re-install Windows and SQLServer. 😀
You have quite demanding users, man!
June 23, 2010 at 11:18 am
Joe Celko (6/23/2010)
1.Rows are not records.
2.SQL programmers do not use BIT flags; that was assembly language and punch cards.
3.Being a primary address of a person is a relationship and...
June 23, 2010 at 10:57 am
Joe Celko (6/23/2010)
...This is one of many reasons that good SQL programmers never use the IDENTITY property (it is not really a column at all).
...
Of cause!
Only very bad SQL...
June 23, 2010 at 10:07 am
Users to drop databases? Why only in test environment?
That is the coolest idea I ever heard of!
😀
June 23, 2010 at 9:55 am
ssc_san (6/23/2010)
...I need to get the count of codes(bc, cd, de) where the codes(ab) status(close)
...
That query does exactly what you have asked for:
SELECT codes, count(*)
FROM ABC
WHERE codes in ('bc', 'cd',...
June 23, 2010 at 8:07 am
pitso.maceke (6/23/2010)
...I just have a problem with your code. When I try dates that includes weekends, I got this message:
(Start Saturday 12H00 and End Monday 09H00)
...
First of all you have...
June 23, 2010 at 7:39 am
From, what I can see, the query I gave you does not return running totals but retuns the count of loggins for each hour for period of time during the...
June 23, 2010 at 5:48 am
Gail,
I've run test more than 5 times (and I did few concurrent queries as well). Please believe me I've tried the best (on my machine and on aour dev server)....
June 22, 2010 at 9:17 am
If you don't care about duplicates and not all letters from A to Z to be used, you can use the following:
INSERT INTO tblExample(fname,sname,email,code)
SELECT fname,sname,email,
LEFT(REPLACE(CAST(NEWID() AS VARCHAR(150)), '-',''),8) AS...
June 22, 2010 at 9:01 am
sql_novice_2007 (6/21/2010)
...Is there any other way than receiving the data in an excel/csv/txt file/xml file or API calls?
...
A lot of other ways:
1. By phone (some one calls you and dictates...
June 22, 2010 at 8:20 am
You could add PrimaryAddressId column into your Person's table, that would ensure the person has only one primary address.
June 22, 2010 at 8:02 am
Attmept to set max memory to its minimum value of 16Mb caused SQL to stop executing any query on midium sized tables :w00t:.
Increased the max memory allotment to 32Mb, made...
June 22, 2010 at 7:54 am
Dave Ballantyne (6/22/2010)
Eugene Elutin (6/22/2010)
Let's try it together, I really want to find the example where it is possible
Why (other than curiosity ) ? It seems a lot simpler to...
June 22, 2010 at 7:37 am
Thank You, Gail.
It almost there. The reason of getting data not in order is using TABLOCK hint.
But now I have another question, when would SQL Server place a TABLOCK on...
June 22, 2010 at 7:24 am
Dave and Gail,
I do totally agree with you on use of "ORDER BY" to ensure the order. Sorry, of cause data is stored logicaly and retrieved in the logical order.
However,
I...
June 22, 2010 at 5:27 am
Viewing 15 posts - 2,701 through 2,715 (of 2,894 total)