Viewing 15 posts - 6,511 through 6,525 (of 7,636 total)
Try this:
--======your variables: fill these in!
declare @myschema SYSNAME, @MYTable SYSNAME
Select @myschema = 'dbo', @MyTable = 'TestTable'
declare @sql nvarchar(max)
Set @sql = 'SELECT * FROM ('
--====== build command string with all of...
June 24, 2008 at 5:32 am
Well on 2005 you could check SYSPROCESSES for a process with program name 'SQLAgent - Generic Refresher'.
I'm not sure what it is on 2000.
June 24, 2008 at 5:09 am
Try it like this:
cmd.Parameters.Add (1,SqlInt).value = 15
(or maybe 0?)
June 23, 2008 at 8:16 pm
Jeff Moden (6/23/2008)
...So... wouldn't that be a Catch-22? ...
More of a "Cache-22" actually ... 😀
June 23, 2008 at 8:11 pm
You need to move this topic to a more appropiate Forum.
June 23, 2008 at 7:33 pm
What happened to the article that this topic was linked to? It appears to be dead.
June 23, 2008 at 7:30 pm
CASE is a Function, not a Statement. "IF.." is a statement.
June 23, 2008 at 7:08 pm
Glad we could help...
June 23, 2008 at 2:27 pm
venki (6/23/2008)
...Now I used Cursors and while loop and completed the task.
Thanks a lot for your suggestions.
...
:angry:
June 23, 2008 at 2:14 pm
Jeff Moden (6/22/2008)
I'm trying to find out if there's a way to do it using a single Pivot.
Heh. What were we saying just yesterday about posters and their unreasonable,...
June 22, 2008 at 11:18 pm
This is why imports should always be to staging tables of NVarchar.
June 22, 2008 at 11:12 pm
Viewing 15 posts - 6,511 through 6,525 (of 7,636 total)