Viewing 15 posts - 5,026 through 5,040 (of 13,876 total)
adisql - Monday, October 16, 2017 7:12 PMHi,I need to save the result with pipe-delimited text with header row.
any suggestions please.Thanks
SSIS...
October 16, 2017 at 7:46 pm
I think that you are going to have to do some more work on this yourself.
If you cannot provide some sort of detail or demonstration which describes the problems,...
October 16, 2017 at 2:07 pm
For that query? The db_reader role or SELECT permissions on the internet schema...
October 16, 2017 at 10:58 am
Why is there an ORDER BY in your INSERT?
Why have you added OPTION (FORCE ORDER) to a query which contains only one table?
If you want to do a...
October 16, 2017 at 6:31 am
October 16, 2017 at 6:02 am
One thing I have noticed in Visual Studio 2015, is...
October 16, 2017 at 5:54 am
October 16, 2017 at 5:43 am
This query gets you part of the way there, I think:SELECT a.Name,
Type1 = IIF(Q0.Type = 1, Q0.Value, 0),
Type2 = IIF(Q0.Type = 2, Q0.Value,...
October 15, 2017 at 4:39 pm
OK, here's a good one. I import my data into a table with all field...
October 15, 2017 at 4:32 pm
October 14, 2017 at 10:42 am
October 14, 2017 at 7:24 am
Dear all,
Can you please let me know how can I get the names of all...
October 13, 2017 at 9:30 am
October 13, 2017 at 9:28 am
October 13, 2017 at 9:10 am
Well done on solving this yourself. I've reformatted your code and posted it below, to make it easier for others to read.DECLARE
@Max_RowID INT
, @Slicing_Rowcount...
October 13, 2017 at 7:03 am
Viewing 15 posts - 5,026 through 5,040 (of 13,876 total)