Viewing 15 posts - 10,771 through 10,785 (of 13,872 total)
selvakumar.sms (4/23/2012)
i have only MDF and LDF files.
By avoiding Gail's questions you are making your own questions more difficult to answer. Please reread her post and then provide the requested...
April 23, 2012 at 5:33 am
anthony.green (4/23/2012)
April 23, 2012 at 2:15 am
Can you get them to change the column delimiter to a pipe (|) as part of that? It might just solve these issues.
April 23, 2012 at 2:05 am
A better (and easier!) idea might be to compare the execution plans for the two queries.
April 21, 2012 at 5:36 am
So ... what's so special about that one column?
You're right about Friday afternoon ... same sentiment here.
April 20, 2012 at 10:07 am
The 'tools' you refer to do not necessarily require anything to be installed on a server - just your client machine...
April 17, 2012 at 9:56 am
Scott Murray-240410 (4/17/2012)
April 17, 2012 at 6:05 am
ashokkumar.ss (4/17/2012)
i just need simple stored procedure to add a single value into multiple tables which has already assigned win foreign and primary keay concept.
tab1 - id...
April 17, 2012 at 2:11 am
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
Viewing 15 posts - 10,771 through 10,785 (of 13,872 total)