Viewing 15 posts - 286 through 300 (of 3,544 total)
Far away is close at hand in the images of elsewhere.
Anon.
February 16, 2018 at 8:23 am
Far away is close at hand in the images of elsewhere.
Anon.
February 16, 2018 at 5:13 am
Just for fun, like a Christmas turkey, lots of STUFFing :hehe:
SELECT
REPLACE(
STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(
STUFF(Column1,58,0,'|')
,55,0,'|')
,52,0,'|')
,49,0,'|')
,46,0,'|')
,43,0,'|')
,40,0,'|')
,37,0,'|')
,34,0,'|')
,31,0,'|')
Far away is close at hand in the images of elsewhere.
Anon.
February 9, 2018 at 1:58 am
Far away is close at hand in the images of elsewhere.
Anon.
January 26, 2018 at 3:00 am
WITH cte (Ig,DATE_,TOTAL,RunningTotal,Debit) AS (
SELECT Ig,DATE_,TOTAL,
SUM(TOTAL) OVER (PARTITION BY Ig ORDER BY SIGN(TOTAL) DESC,DATE_),
SUM(CASE WHEN TOTAL < 0 THEN -TOTAL ELSE 0...
Far away is close at hand in the images of elsewhere.
Anon.
January 23, 2018 at 1:39 am
WITH cte (Ig,DATE_,TOTAL,RunningTotal,Debit) AS (
SELECT Ig,DATE_,TOTAL,
SUM(TOTAL) OVER (PARTITION BY Ig ORDER BY DATE_),
SUM(CASE WHEN TOTAL < 0 THEN -TOTAL ELSE 0 END) OVER (PARTITION BY...
Far away is close at hand in the images of elsewhere.
Anon.
January 22, 2018 at 3:26 am
How many negative values will there be per Ig
Far away is close at hand in the images of elsewhere.
Anon.
January 22, 2018 at 2:24 am
WITH cte (Ig,DATE_,TOTAL,RowNum) AS (
SELECT Ig,DATE_,TOTAL,
CASE WHEN TOTAL < 0 THEN 1
ELSE ROW_NUMBER() OVER (PARTITION BY Ig ORDER BY DATE_ ASC)
END
FROM #TempStk
)
Far away is close at hand in the images of elsewhere.
Anon.
January 22, 2018 at 2:07 am
Use a Data Flow Task with OPENROWSET in an OLE DB Source and output to a Recordset Destination
Far away is close at hand in the images of elsewhere.
Anon.
November 28, 2017 at 6:57 am
Far away is close at hand in the images of elsewhere.
Anon.
November 21, 2017 at 2:07 am
I'd be interested in Auditing read/access/usage of a table 🙂
Far away is close at hand in the images of elsewhere.
Anon.
November 14, 2017 at 7:17 am
Far away is close at hand in the images of elsewhere.
Anon.
November 13, 2017 at 6:00 am
Untested but something like this
SQL.CommandText = "INSERT INTO [MyDatabase].[dbo].[MyTable] ([my_id]) VALUES (@my_id)"
SQL.ActiveConnection = Cn
SQL.Parameters.Append SQL.CreateParameter("@my_id", adVarChar, adParamInput, 50, Value)
RowNum = 1
While Sheets("Sheet1"),Cells(RowNum,5).Value...
Far away is close at hand in the images of elsewhere.
Anon.
November 13, 2017 at 5:33 am
Do you mean the values in the column for all rows in the spreadsheet?
Far away is close at hand in the images of elsewhere.
Anon.
November 10, 2017 at 10:06 am
Far away is close at hand in the images of elsewhere.
Anon.
November 9, 2017 at 1:54 am
Viewing 15 posts - 286 through 300 (of 3,544 total)