Viewing 15 posts - 31 through 45 (of 141 total)
This should be faster...
Select Max(Col1) as Col1, Col2
INTO #Temp
From YourResultSet
Where Col2 IS NOT NULL
Group By Col2
Select T1.Col1, ISNULL(T1.Col2,
(
Select TOP 1 T2.col2 from #Temp T2
where T2.Clol1 < T1.Col1
Order by...
January 5, 2007 at 4:01 pm
I was trying to illustrate how a logical expression involving a NULL will return a NULL rather than TRUE or FALSE
This is not always true.
SET...
January 5, 2007 at 3:32 pm
where ISNULL(field, '') <> 'O'
January 4, 2007 at 2:44 pm
January 4, 2007 at 2:42 pm
where
completiondate >
CASE DATEPART(HH, getdate())
WHEN 10 then (Getdate() - 1) -- yesterday morning
When 14 then DateAdd(hh, -4, getdate()) -- 10AM today
End
NOTE: you specified exact times (equal to 10).
January 4, 2007 at 2:19 pm
Select within a select.
There's not much info here to work with but this should get you started.
Select T1.Col1, ISNULL(T1.Col2,
(Select T2.col2 from YourResultSet ...
January 4, 2007 at 2:03 pm
Try this...
SET @Descript =
'--- Requestor ---' + char(13) + char(10) + char(13) + char(10) +
'Employee Number: ' + ISNULL(@EmployeeID, '') + char(13) + char(10) +
'Employee Name: '...
January 4, 2007 at 1:43 pm
You can debug your SPs thru Visual Studio. You can then see the values of the variables being passed.
January 2, 2007 at 6:13 pm
Indeed, use the double quotes.
Merry Christmas! ß Click Here
December 21, 2006 at 4:30 pm
Maybe it would be better to replace the Send Mail Task with a TransactSQL Task and use XP_Sendmail.
December 21, 2006 at 4:28 pm
Merry Christmas! ß Click Here
December 21, 2006 at 2:05 pm
Sorry, after rereading your post, I realized I misunderstood you. Here you go...
da.Fill(ds, "YourTableName);
da2.Fill(ds, "YourNextTableName);
ds.SaveXML("path");
December 20, 2006 at 8:34 pm
use ds.readXml then,
isn't there a ds.Tables(0).tableName or something?
December 20, 2006 at 8:01 pm
Viewing 15 posts - 31 through 45 (of 141 total)