Viewing 15 posts - 48,346 through 48,360 (of 59,064 total)
Just for grins, I'd still like to know the naming convention of the files that aren't empty../. 😉
September 11, 2008 at 6:37 pm
Those are all good, but let's revisit the OP's restrictions...
xp_fixeddrives returns FREE disk space, but not TOTAL disk space.
xp_cmdshell will not work because this is a high security place.
sp_OACreate, sp_OAMethod,...
September 11, 2008 at 6:34 pm
virgilrucsandescu (9/10/2008)
1a - select * from import_cc_requests where reference not in (select reference from import_cc_payments )
or
1b - select * from import_cc_requests where rtrim(reference) not in (select rtrim(reference)...
September 10, 2008 at 10:38 pm
Heh... you want to do 12 "IF's" per query, Jody? No, no need for IF's here. You didn't post any test data so the outer query...
September 10, 2008 at 9:28 pm
Crud, I made a mistake on the fiscal year :blush:... don't use the code above... I'll post a correction soon.
September 10, 2008 at 9:24 pm
Sorry... deleted this post... I made an error in the code. Repaired further on below...
September 10, 2008 at 9:14 pm
Lowell (9/10/2008)
two also i prefer to use a left join syntax instead..
Check the execution plans of both on a set of big tables sometime...
September 10, 2008 at 8:22 pm
What is the naming convention for the pairs of files?
September 10, 2008 at 8:17 pm
Fraggle (9/10/2008)
Just make sure you don't kill any...
September 10, 2008 at 8:14 pm
If you use parameters on either proc, you may be fighting "parameter sniffing". Google it for a wealth of information.
September 10, 2008 at 8:14 pm
Wow... although I've not needed to use it, I've heard about TableSample before. Didn't know it would return a random number of rows in the rows mode. What...
September 10, 2008 at 7:58 pm
Heh... thanks for the confidence in the Tally table, Gary, but I don't believe it can be made to number rows for what's essentially a 1 row "paging" system. ...
September 10, 2008 at 6:04 pm
Sergiy (9/10/2008)
khushbu.kumar (9/10/2008)
But the here posted code was just a snippet
i really dont know how many rows can be present(i'm selecting them on the basis of...
September 10, 2008 at 5:56 pm
anthony.evans (11/15/2007)
simple but effective solution in sql 2000 , modified to return each case statement result in different column , effectively creating pivot report.thank you
If you'd like to see more...
September 10, 2008 at 5:46 pm
Absolutely not... if you want to install on some version of Windows for a desktop, you need to buy the Developers Edition... it costs less than a good book on...
September 10, 2008 at 5:27 pm
Viewing 15 posts - 48,346 through 48,360 (of 59,064 total)