Viewing 15 posts - 1,111 through 1,125 (of 3,543 total)
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...
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...
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...
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...
April 19, 2011 at 7:04 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...
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 😀
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...
April 12, 2011 at 6:39 am
Change @inputQuery to output only first column and insert into temp table with single column
April 8, 2011 at 6:28 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...
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...
April 7, 2011 at 7:09 am
You must supply the (PrimaryKey) column list as well ie
SET IDENTITY_INSERT BackupDatabase..TableA ON
DELETE
FROM PrimaryDatabase..TableA
OUTPUT Deleted.PrimaryKey
INTO BackupDatabase..TableA (PrimaryKey)
WHERE 1=1
SET IDENTITY_INSERT BackupDatabase..TableA OFF
April 7, 2011 at 7:04 am
Viewing 15 posts - 1,111 through 1,125 (of 3,543 total)