Viewing 15 posts - 2,911 through 2,925 (of 5,111 total)
October 10, 2017 at 9:32 am
You can reference the db name more than once in your query using ?. Thus:Declare @unuseddbs Table(dbname varchar(100), [last_read] NVARCHAR(255), [last_write] NVARCHAR(255) )
INSERT INTO @unuseddbs
EXECUTE...
October 10, 2017 at 9:01 am
Sorry a bit late to returning, works been busy.
Unfortunately (possibly unlike Steve) I'm struggling to realise what your requirement is. What, for example, is determining your FIFO. I...
October 10, 2017 at 8:49 am
Mm, Like Phil says, looping through files in a directory in SSIS is a trivial task. No only that, but the ability to then archive them is just as simple...
October 10, 2017 at 8:32 am
October 10, 2017 at 6:36 am
Use SSIS and a For Each Loop on the directory where you are storing your files.
October 10, 2017 at 6:01 am
They just want essentially to list whats in the tables - like a...
October 10, 2017 at 3:39 am
October 10, 2017 at 3:33 am
You can output xml from SQL Server, however, I wouldn't say that it's my preferred method. Your best option, in all honesty, would be to ask your web developer to...
October 10, 2017 at 3:15 am
How are you trying to find it, in the start menu navigation? Try simply trying "SQL Server" into the start Menu, it should show up. Alternatively, you could open it...
October 10, 2017 at 3:03 am
October 10, 2017 at 2:28 am
Those don't appear to to reference the report your running anywhere. I would expect to see run time requests in the log, however, I can't even see any.
Apart...
October 10, 2017 at 1:50 am
October 9, 2017 at 9:58 am
October 9, 2017 at 9:36 am
Using the vTally table, i created a table with 10,000,000 rows:SELECT TOP 10000000 *, ABS(CHECKSUM(NEWID()) % 200) AS RandNo, ABS(CHECKSUM(NEWID()) % 200) AS PrevRandNo
INTO RandomNumbers
FROM vTally V;
October 9, 2017 at 9:18 am
Viewing 15 posts - 2,911 through 2,925 (of 5,111 total)