Viewing 15 posts - 10,786 through 10,800 (of 13,879 total)
So what do you suggest? what should we do to win the match?
Study the play of Barcelona.
Not really anything to do with SQL Server.
April 16, 2012 at 12:31 pm
Actually the statement previous to the WITH (CTE) needs to be terminated with a semi-colon.
Grrrr! Correct 🙂
April 16, 2012 at 10:26 am
Learner1 (4/16/2012)
its a raw data coming from old source file..this is my source ...no PK is defined here in the file
OK - what method are you using to read the...
April 16, 2012 at 10:13 am
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
Viewing 15 posts - 10,786 through 10,800 (of 13,879 total)