Viewing 15 posts - 10,786 through 10,800 (of 13,876 total)
That does not look like a real-world table to me!
What is the PK?
April 16, 2012 at 10:02 am
ewhitaker (4/16/2012)
ok, never seen that structure before haha..so would i just form the query around everything you pasted? and whats with the ";" at the beginning
Read up on CTEs -...
April 16, 2012 at 7:30 am
drew.georgopulos (4/16/2012)
gonna try that...should be less tediousthanks very much
drew
No problem - hope it works.
April 16, 2012 at 7:06 am
drew.georgopulos (4/16/2012)
Light bulb just went off....did you mean do it in the connection manager?
Yes, sorry - exactly what I meant.
April 16, 2012 at 7:03 am
drew.georgopulos (4/16/2012)
i am importing from Unix into SQL Server...the data dictionary is in Excel
OK. Excuse my lack of Unix knowledge here. If this is a start position/length scenario, why are...
April 16, 2012 at 6:48 am
If you are importing from Excel to SQL Server, where does XML come into it?
April 16, 2012 at 6:33 am
As I am now planning on omitting the double quotes I need to ensure no stray commas messes anything up!
If you used pipes, they would not. But I take your...
April 16, 2012 at 6:26 am
Can you come at this from a different angle and instead change your delimiter? You'll probably have less trouble if you use a pipe (|), for example.
April 16, 2012 at 5:16 am
Larry Page(Ehsan.Akbar) (4/16/2012)
Phil Parkin (4/16/2012)
Perhaps you would provide a fuller statement of requirements to help us understand why you...
April 16, 2012 at 1:14 am
The longer I watch this thread unfold, the more troll-like it seems.
Perhaps you would provide a fuller statement of requirements to help us understand why you are doing this. And...
April 16, 2012 at 12:45 am
deandeandeandean1 (4/14/2012)
Sir ,can you give me a detailed solution . Please sir !
I don't think that Gail is a 'sir'.
April 15, 2012 at 6:00 am
edvard 19773 (4/15/2012)
I am aware of, that your solution is much faster than a row by row solution, and in this case, its...
April 15, 2012 at 4:26 am
edvard 19773 (4/15/2012)
Not urgent, but how to make it in a WHILE loop instead.
I do not need it here, but it seems wrong, that i cannot...
April 15, 2012 at 2:44 am
Use Execute Package tasks instead?
April 12, 2012 at 5:43 am
If you have it installed somewhere, you could fire up Profiler and check the actual queries that are being sent from the front-end app. Might give you some clues.
April 12, 2012 at 5:21 am
Viewing 15 posts - 10,786 through 10,800 (of 13,876 total)