Viewing 15 posts - 1,786 through 1,800 (of 3,232 total)
Have you tried using DTS? This would be a pretty simple task using the text file source connection.
May 13, 2008 at 12:25 pm
SELECT 'A',
aID,
Col,
aBol1,
...
May 6, 2008 at 10:16 am
I'll second that. In fact, it would be good if you'd include sample data from before and after your cursor runs. This seems like a pretty straight forward...
April 30, 2008 at 4:47 pm
Thanks for picking this one up Matt. I think I messed with the query just before posting it becuase I had the COUNT(*) included when I was playing with...
April 30, 2008 at 4:12 pm
Put the error code into a variable so you can return it.
SET @SQLError = @@ERROR
IF @SQLError <> 0 .......
You can then later query @SQLError and get the actual...
April 30, 2008 at 12:59 pm
Your average CPU time looks good. When your CPU usage goes up to 100%, how long does it stay there for? If you are just seeing spikes up...
April 30, 2008 at 12:55 pm
SET NOCOUNT ON
DECLARE @r TABLE (ID int, DateShipped datetime, ItemId int)
INSERT INTO @r
SELECT 1, '1/1/2005', 1 UNION ALL
SELECT 2, '1/1/2005', 2 UNION ALL
SELECT 3, '1/2/2005', 1 UNION ALL
SELECT 4,...
April 29, 2008 at 1:31 pm
We'll need more helpful information from you on this. You've posted part of your table, where's the rest? The table you've posted has 2 columns, but the...
April 28, 2008 at 4:08 pm
If SQL Oracle's answer does not do it for you, you'll want to give us some more info such as sample data, expected results, and how 'bout posting the queries...
April 28, 2008 at 4:01 pm
Great. Thanks for posting your results.
April 24, 2008 at 1:10 pm
This is a simple task if you use the RESTORE DATABASE T-SQL command.
First, get the file info from the backup file:
RESTORE FILELISTONLY
FROM DISK='backup file path and name'
Then, restore WITH...
April 24, 2008 at 9:30 am
What you need is another outer join. Check out this example and see if you can get your UPDATE statement from it:
DECLARE @STU TABLE (SC int, SN int)
DECLARE @PRG...
April 18, 2008 at 4:27 pm
Procedure cache hit rate refers to how often a stored procedures execution plan is found in the procedure cache. Buffer cache hit rate refers to how often a request...
April 18, 2008 at 3:31 pm
From your description, I am not clear on whether you are trying to update the 3rd table or simply add it to the JOIN. Can you clarify this for...
April 18, 2008 at 3:28 pm
Create an ActiveX task and simply set the variables to zero/blank depending on the data types.
April 18, 2008 at 3:23 pm
Viewing 15 posts - 1,786 through 1,800 (of 3,232 total)