Viewing 15 posts - 1 through 15 (of 22 total)
Oh, and I have access to Sql Server 2012. The second part of the script is my solution and gives the expected result. I'm just checking to see...
August 30, 2013 at 10:14 am
The first query is there to create a sample table. Does it not work?
August 30, 2013 at 10:12 am
2008, it gives no error details that I see. What happens if I select Yes?
December 14, 2012 at 7:13 am
I got nothin, if you specify text delimiter as " ' ", then it will not recognize a comma as a delimiter if it is within single quotes. ...
October 25, 2012 at 1:31 pm
Sorry, misread the first error. Not sure how to help you with that one, the wizard on 2008 does not include a drop table statement as far as I...
October 25, 2012 at 1:23 pm
First, it looks like you have a table in your db with that name already. that is your first error. the other error means that the column in...
October 25, 2012 at 1:17 pm
IS this what you mean,
Select Case when bit = 1 then 'True' Else 'False' END
October 25, 2012 at 12:19 pm
I am not sure what you mean but if you have SSIS you can build a package that will import multiple CSV files into a table.
October 25, 2012 at 12:05 pm
I don't understand, are you trying to insert or update these values?
October 25, 2012 at 12:01 pm
Why are you putting the case statement in a where clause. Maybe bring back relevant values and then pick and choose with the case statement in select clause. ...
October 25, 2012 at 11:47 am
That was what I needed to get it to run!
October 4, 2012 at 11:40 am
Thank you guys very much for the help and the additional reading! Good Stuff!
October 4, 2012 at 11:36 am
Viewing 15 posts - 1 through 15 (of 22 total)