Viewing 15 posts - 5,146 through 5,160 (of 13,877 total)
September 25, 2017 at 1:46 pm
September 25, 2017 at 10:20 am
September 24, 2017 at 3:14 pm
OK, did you consider adding the new columns to the old DB and then doing the scripting?
September 24, 2017 at 6:23 am
how can i do it ? after taking data script and run on new database...
September 24, 2017 at 6:12 am
September 22, 2017 at 10:36 am
September 22, 2017 at 8:16 am
What are you all using for Version and Source Control? And how do you...
September 22, 2017 at 7:07 am
September 22, 2017 at 6:12 am
My SQL Prompt settings gave me this. Not perfect, but better.UPDATE a
SET
a.source = 'CP'
, a.PREVENTCOPY = CR.Landing.PREVENTCOPY
, a.PREVENTPRINT = CR.Landing.PREVENTPRINT
, a.ISAMOVAR = CR.Landing.ISAMOVAR
, a.ID...
September 21, 2017 at 2:14 pm
September 21, 2017 at 1:05 pm
One further small request for help... If I wanted to make...
September 20, 2017 at 12:11 pm
This should do it - no CURSOR required.WITH Missed
AS
(
SELECT
t.Section
, t.Missed
, PrevMissed = LAG(t.Missed, 1) OVER (PARTITION BY t.Section
September 20, 2017 at 11:52 am
September 20, 2017 at 11:43 am
I get the below error from this sqlselect (serno * 100) / ...
September 20, 2017 at 11:03 am
Viewing 15 posts - 5,146 through 5,160 (of 13,877 total)