Viewing 13 posts - 16 through 28 (of 28 total)
oops..i did not notice.
But this script is for Sql 2000. Is there any alternative to perform this in 2000?
There is a PIVOT table option in books online..but it does exactly...
January 9, 2008 at 1:40 pm
Hi Jason,
Does this Unpivot work for SQL 2000?
January 9, 2008 at 1:18 pm
Ok i will look about Paging.
But i felt that i will restrict the records in the DB level than doing it in the Front end
December 13, 2007 at 11:37 am
Basically, this SP is used by front end VB. So if the user wants records 1-50 displayed in the page then i wud use 2 variables like iStartRowNum = 1...
December 13, 2007 at 11:22 am
Set ROWCOUNT n
select * from project_lkup
Set ROWCOUNT 0
December 13, 2007 at 11:14 am
🙁
Rowcount is not recognised.
December 13, 2007 at 11:13 am
Oh...
Probly i would wanna talk this to my PL
Thanks...
November 8, 2007 at 1:45 pm
Well I will compile all the action and schedule it as a SQL Job.
So it will be deployed in production DB. The user neednt do anything with this, as the...
November 8, 2007 at 1:39 pm
Hi Jason,
it works perfect. thanks for your time & help.
Also one more thing. Now this folder is created and i also have a script to copy files into this folder.
I...
November 8, 2007 at 1:27 pm
Yes. It should somewhat be a combination of name and the date.
Coz the folders will be stored created periodically and stored in the same server.
So everytime the Job creates a...
November 8, 2007 at 1:09 pm
Oh..this is quite a simple set of code.
I sure learnt something new 🙂
I will work on the code you sent and get the idea of it.
Thanks a bunch !!
Rama
November 8, 2007 at 8:09 am
Could you help me using the xp_cmdshell command? I have learnt about it, but not well verse in writing a procedure to perform the operation.
Thanks,
rama
November 8, 2007 at 7:58 am
Viewing 13 posts - 16 through 28 (of 28 total)