Viewing 15 posts - 1,666 through 1,680 (of 3,232 total)
Well, there are a few ways you can do this. Are you trying to do a one-time insert of data or are you trying to create a re-usable automated...
July 3, 2008 at 9:22 am
What you're asking for is a bit broad. It sounds like you need to develop a change management process to propogate your schema and static data changes to your...
July 2, 2008 at 4:35 pm
I'm just heading out of the office, so I don't have time to write the script for you, but what you'll need to do is create a file system object...
July 2, 2008 at 4:31 pm
I'm not quite sure I'm following you here. It would help if you would post some sample data and an example of the result set that you are after...
July 2, 2008 at 4:13 pm
Are you still looking for help on this?
I'll have to say that after reading through the post a couple of times, I'm still not quite sure what you are trying...
July 2, 2008 at 3:03 pm
I think Jeff is reffering to ALTER TABLE SWITCH ... for partitioned tables
Yes, this is what I thought also, but the OP had not mentioned using SQL Server 2005...
July 2, 2008 at 2:50 pm
Not trying to be obtuse, but can you expand on this a bit Jeff? What issues are there with BCPing directly into the final table? Also, what do...
July 2, 2008 at 2:02 pm
The condition is i dont want to go for intermediate tables or have any
additional identity column
Who has placed these conditions on your solution? The only way I can see...
June 20, 2008 at 12:14 pm
I understand that you've only posted this becuase you've ran into a roadblock. All I'm saying is that in order to find the table, you have to be able...
June 20, 2008 at 9:30 am
Unfortunately, I do not have a documented resource. I learned this last week at TechEd during a session with Paul Randall and Kimberly Tripp. I don't recall how...
June 20, 2008 at 9:19 am
INSTR and MID are not T-SQL functions so that won't work. Search SSC for 'split function. You'll find several viable options.
June 19, 2008 at 11:27 am
It's folks like that that make way for us to make a living.
Long live the Stupid!!
June 19, 2008 at 11:11 am
Actually, the only way you can guarantee the order in which SQL Server will return the rows is to use the ORDER BY clause. All SELECT statements without an...
June 19, 2008 at 11:08 am
Viewing 15 posts - 1,666 through 1,680 (of 3,232 total)