Viewing 15 posts - 52,411 through 52,425 (of 59,070 total)
I've never seen BCP do such a thing... what are you using to call the BCP with?
February 20, 2008 at 12:46 pm
I don't know what it is... everything in the command you printed looks fine. I even tried it with substitution of colums, etc, and it works just fine on...
February 20, 2008 at 12:42 pm
Huh... looks like you've done everything correctly... what are the clunky characters and are they always the same or not?
February 20, 2008 at 12:05 pm
Susane, Matt is spot on... you won't find a faster way to do that especially in light of a million rows or so, in my humble opinion.
Undoubtedly, you will run...
February 20, 2008 at 11:57 am
Lynn is spot on.
Just to expose another conversion method that's all math and nothing character based...
[font="Courier New"]UPDATE MyTable SET xyz_new = SELECT DATEADD(yy,XYX-1900,0)[/font]
Sounds obvious, but make sure that step 2...
February 20, 2008 at 11:33 am
It seems there's a bit of confusion here...
First, when you create the text file, do you want it done automatically as part of a stored procedure or do you...
February 20, 2008 at 11:23 am
sqluser (2/20/2008)
try this one also ....DECLARE @s1 varchar(16)
DECLARE @s2 varchar(16)
SET @s1 = '1232'
SET @s2 = 'tete,1232'
SELECT @s1,@s2
SELECT SUBSTRING(@s2,CHARINDEX(@s1,@s2,1),LEN(@s1))
---
Careful!!!! You must still include the delimiter wrapping or you will get...
February 20, 2008 at 11:04 am
Adam Haines (2/20/2008)
declare @filter varchar(25)
set @filter = 'test|test2'
DECLARE @x XML
SET @x =...
February 20, 2008 at 7:43 am
Ok... I'm a bit new to 2k5... just installed it a couple of months ago and still coming up to speed on how some of the new features work.
Can someone...
February 20, 2008 at 6:35 am
You pictures didn't show up because you didn't attach them.
February 19, 2008 at 10:53 pm
If you have a "friendly" DBA, (s)he will be able to setup a proxy user on a job that anyone could run at any time.
Good lesson here, though... most DBA's...
February 19, 2008 at 8:41 pm
If it's not too far from work, go into work once in a while. Otherwise, you're fine. Just continue to make sure that they know you exist. ...
February 19, 2008 at 8:38 pm
Yes you can... like this...
DECLARE @S1 VARCHAR(100)
DECLARE @S2 VARCHAR(100)
SET @S1 = '5'
SET @S2 = '1,2,3,4,55,6'
SELECT PATINDEX('%'+@S1+'%',@S2)
But, you notice that in...
February 19, 2008 at 8:33 pm
What was the error... partial file transmission or just a bad row or maybe a rowcount at the end of the file? What was the error?
February 19, 2008 at 8:18 pm
Awesome. And very simple, to boot! Thanks Chris! Neat redirection trick.
February 19, 2008 at 8:14 pm
Viewing 15 posts - 52,411 through 52,425 (of 59,070 total)