Unfortunately not. The use of GO splits queries into batches and a proc can only be one batch. BOL states that 'A table cannot be altered and then the new columns referenced in the same batch'. Therefore I think you will not be able to do what you want unless you can split the job […]
2003-05-27
2 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-23
It seems there's been a bit of confusion at my end-i'm on here on behalf of my boss who told me before, that the original machine is NT4. I have just learned that it is in fact 2000. Apologies for the false information, but thanks all the same for trying to sort it! We checked […]
2003-05-21
Hi, I think the BIT option would be faster, not sure by how much though. When comparing two BITs you are literally comparing at a Bit level - value A (0 or 1) compared against value B (0 or 1). When comparing two INTs you have to pattern match the 32 bits (as an INT […]
2003-05-20
1 reads
Sorry, select @datestr = cast(year(@todate) as char(4)) + '-' + cast(month(@DOB) as char(2)) + '-' + cast(day(@Dob) as char(2)) DOB might be a leap day as you said but todate is presumably current date = 2003 which is not -add these together you get 2003-02-29 - which is invalid and yes - varchar would be […]
2003-05-16
1 reads
2003-05-01
Thanks, but that only returns a list of the SP Parameters (twice) and not the columns in the resultset.
2003-05-01
1 reads
Do you want this? id 00001 00002 00003 ? If so, select right('00000' + convert(varchar,id), 5) from ..... etc Jeremy
2003-05-01
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers