Viewing 15 posts - 2,911 through 2,925 (of 5,109 total)
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 10, 2017 at 8:32 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 10, 2017 at 6:36 am
Use SSIS and a For Each Loop on the directory where you are storing your files.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 10, 2017 at 6:01 am
They just want essentially to list whats in the tables - like a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 10, 2017 at 3:39 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 10, 2017 at 3:03 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 10, 2017 at 1:50 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 9, 2017 at 9:58 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 9, 2017 at 9:36 am
Using the vTally table, i created a table with 10,000,000 rows: Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.SELECT TOP 10000000 *, ABS(CHECKSUM(NEWID()) % 200) AS RandNo, ABS(CHECKSUM(NEWID()) % 200) AS PrevRandNo
INTO RandomNumbers
FROM vTally V;
Larnu.uk
October 9, 2017 at 9:18 am
TheCTEGuy - Monday, October 9, 2017 8:50 AMCan you prove that with an example.
What do you mean prove? That is pasted...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 9, 2017 at 8:53 am
Viewing 15 posts - 2,911 through 2,925 (of 5,109 total)