Viewing 15 posts - 1,756 through 1,770 (of 3,232 total)
Here's some good reading for you folks who may be new to dynamic sql:
May 22, 2008 at 1:34 pm
In this situation many developers tend to use a cursor
Developers resort to using cursors for 2 reasons:
1. The problem domain's complexity makes it difficult for them to envision the set...
May 22, 2008 at 1:28 pm
I know you've already said that a view may not work for you, but can you clarify what your concerns are with this? What do you mean by 'a...
May 22, 2008 at 1:18 pm
As rroque has stated, queries in a UNION/UNION ALL must have the same number and types of columns in the SELECT. So the UNION ALL in your first query...
May 22, 2008 at 1:12 pm
Richter,
Stay away from the cursors/loops solutions and stick with the set based methods that Grant and Matt have posted. If you can, post back some feedback so we...
May 22, 2008 at 1:09 pm
Yea, that's what I was getting at when I said 'how the data in the rows are used to identify where it belongs'. Most files like this that I've...
May 20, 2008 at 3:02 pm
That's kind of what I thought based on the data you posted. This probably means also that you'd want to import the data into more than one table in...
May 20, 2008 at 2:23 pm
So are these flat files fixed length files with one line entry representing one row in one table? If so, this is a pretty straight forward bcp (with a...
May 20, 2008 at 1:55 pm
Mark,
I went back to the beginning and read your original post. Based on the number of unknowns from your original post, I am not about to begin to...
May 20, 2008 at 1:24 pm
Also, create the table first if you can. When you run a SELECT INTO statement to create a table, system resources are locked for the duration of the create...
May 20, 2008 at 10:56 am
Did I read correctly, it is taking 50 minutes to query a table with only 5000 rows?
May 20, 2008 at 10:53 am
I just based it on the OP's post.
What a novel concept.....:)
May 20, 2008 at 9:00 am
Hi John,
The GUID in table A comes from the form directly but it has data which needs to go to Table B, Table c etc and when the data...
May 20, 2008 at 8:58 am
How many SSC logins do you have?
May 20, 2008 at 8:48 am
Viewing 15 posts - 1,756 through 1,770 (of 3,232 total)