Viewing 15 posts - 1,111 through 1,125 (of 3,544 total)
In a delete trigger you have a 'deleted' table containing the rows to be/have been deleted so you can use this to update ie
UPDATE c
SET c.IsEnabled=0
FROM dbo.COUNTRY c...
Far away is close at hand in the images of elsewhere.
Anon.
April 21, 2011 at 4:12 am
ChrisM@home (4/21/2011)
Evolution in practice - don't you just love it 😀
It is darn near impossible to improve on Jeff's solutions, so must make the most of it while I can...
Far away is close at hand in the images of elsewhere.
Anon.
April 21, 2011 at 3:31 am
Jeff Moden (4/20/2011)
If we don't know the length, then we can force the max length for positive BIGINTs and simply remove all spaces afterwards.
Also if you append the separator to...
Far away is close at hand in the images of elsewhere.
Anon.
April 21, 2011 at 3:20 am
You will need to sequence the data in a temp table and then pivot
CREATE TABLE #A (RowID int IDENTITY(1,1),ColNum int,[item number] varchar(20), [product batch] int, [price] decimal(9,2))
INSERT #A (ColNum...
Far away is close at hand in the images of elsewhere.
Anon.
April 19, 2011 at 7:32 am
I suspect it is your collation set to 2000 default LATIN1_General_CI_AS
Try changing the collation during the check, ie
IF @c COLLATE SQL_Latin1_General_CP1_CI_AS LIKE '[0-9A-Z ]' COLLATE SQL_Latin1_General_CP1_CI_AS
Note that I changed...
Far away is close at hand in the images of elsewhere.
Anon.
April 19, 2011 at 7:04 am
Is there a fixed maximum for x ?
Far away is close at hand in the images of elsewhere.
Anon.
April 19, 2011 at 6:36 am
Dave Ballantyne (4/12/2011)
David Burrows (4/7/2011)
Dave Ballantyne (4/6/2011)
Any other threadzian going to be at sqlbits ?Yarp, Saturday.
Good to meet you on saturday, it was a fun weekend 🙂
And you too...
Far away is close at hand in the images of elsewhere.
Anon.
April 12, 2011 at 9:54 am
Steve Jones - SSC Editor (4/12/2011)
you cannot, and will not, win that argument. Best to let it go.
Non Illegitimi Carborundum 😀
Far away is close at hand in the images of elsewhere.
Anon.
April 12, 2011 at 8:27 am
UMG Developer (4/11/2011)
thamatrix1436 (4/11/2011)
Conversion failed when converting date and/or time from character string.
And thats w/ and w/o the PatIndex in the...
Far away is close at hand in the images of elsewhere.
Anon.
April 12, 2011 at 6:39 am
Thanks Flexdog for helping 🙂
Far away is close at hand in the images of elsewhere.
Anon.
April 11, 2011 at 1:50 am
How many rows per employee?
Far away is close at hand in the images of elsewhere.
Anon.
April 8, 2011 at 6:57 am
Change @inputQuery to output only first column and insert into temp table with single column
Far away is close at hand in the images of elsewhere.
Anon.
April 8, 2011 at 6:28 am
:hehe::-D:crazy::blink::crying::-P
Far away is close at hand in the images of elsewhere.
Anon.
April 8, 2011 at 6:08 am
gregory.anderson (4/7/2011)
Edit: After re-reading your reply, do I just need to specify the columns that I'm inserting into the archive table then? I'll try that.
Yes.
Change
Into Archive..CorrespondenceReference
To
Into...
Far away is close at hand in the images of elsewhere.
Anon.
April 7, 2011 at 7:43 am
Lowell (4/7/2011)
Is there a question in here somewhere? are you trying to do the same in TSQL? this looks like it is concatenating 60 cells into a comma delimited striung.
How...
Far away is close at hand in the images of elsewhere.
Anon.
April 7, 2011 at 7:09 am
Viewing 15 posts - 1,111 through 1,125 (of 3,544 total)