Viewing 15 posts - 601 through 615 (of 1,186 total)
Please don't double post. Response can be found here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=154218
January 7, 2005 at 5:19 am
Maybe building all the parts and then put them together is the route to go....
January 7, 2005 at 5:16 am
Going along with Frank, IF you want a daterange and DON'T want to look at TIME and you don't want to use CONVERT due to performance THEN
Why not advance your...
January 7, 2005 at 5:15 am
Bad image link? Or is it just me???
January 6, 2005 at 5:38 am
Not my best coding and I'm sure there is a better way but
SELECT T3.Site, T3.IPAddress, T4.HostName
FROM Table3 T3
LEFT JOIN Table4 T4 ON T3.Site = T4.Site
UNION
SELECT T4.Site, T3.IPAddress, T4.HostName
...
January 6, 2005 at 5:36 am
Are you positive you are populating the DataGrid properly? I know that I have had problems in the past and have switched to the Hierarchial FlexGrid which seems to be...
January 6, 2005 at 5:27 am
Ok IF the system has flags that currently (assumption here) kick off various different jobs (hopefully SQL) then create ALL the DTS packages and then schedule them (via right-click) and...
January 5, 2005 at 5:53 am
SET is better than SELECT for a couple of different reasons
January 4, 2005 at 4:35 pm
Adding the BEGIN TRAN..COMMIT isn't a big deal should be easy and BOL has decent examples.
What you could do is in the SP that is being called write the information...
January 4, 2005 at 4:30 pm
Why not have an NT group created that has the permissions already established for it in SQL and then as people come and go add/remove them from the group via...
January 4, 2005 at 12:52 pm
Ok, I understand the mentality of BRUTE forcing GETDATE() apart to be just a DATE but why not use the following?
CONVERT(VARCHAR(10), GETDATE(), 101) ??
And as a bonus WHY is it...
January 4, 2005 at 12:49 pm
use a @TABLE variable to store the errors. These do not get rolled back the same as other items during a ROLLBACK TRANS. Why do I know this? I have...
January 3, 2005 at 5:42 am
Directly under the INSERT statement have the following
IF @@ERROR <> 0
BEGIN
RETURN(@@ERROR)
END
This will change the RETURN code from the SP to be the error code and exit the...
January 3, 2005 at 5:40 am
IF it is a #temp table then on DROP/RECREATE it will reset the IDENTITY to 1
IF is is a "temp" table meaing it is in existence all the time i.e....
January 3, 2005 at 5:37 am
Viewing 15 posts - 601 through 615 (of 1,186 total)