Viewing 15 posts - 4,291 through 4,305 (of 5,504 total)
As far as I can see the problem is that your Data1 element is part of ReferenceDatas/ReferenceData not but you declare it as being part of the Reference node.
Try to...
February 12, 2010 at 1:02 pm
You could change
select @sql=
'
select * from
to
select @sql=
'
select * INTO #TargetTable
from
But make sure to include the existance check including a conditional drop table ...
February 12, 2010 at 12:51 pm
Did you actually try your sample data within a test database?
It seems like you didn't...
Please modify your sample data.
Side note: You're on the right track in terms of providing the...
February 11, 2010 at 5:02 pm
mister.magoo (2/11/2010)
...This kind of dynamic sql works up to a point, but it's not what SQL is good at - let your favoured reporting tool do the formatting...
Would you mind...
February 11, 2010 at 4:58 pm
The concept itself is described in the last link in my signature.
The reason for all the ''' is simple:
If you want to get the dynamic sql to look like "...CASE...
February 11, 2010 at 4:34 pm
How about changing your data model to be a relational one rather than that ETL stuff?
It's always a PITA to try to get relational transformation out of an object oriented...
February 11, 2010 at 4:22 pm
Please provide table definition and some sample data to play with as described in the first link in my signature.
February 11, 2010 at 12:44 pm
Roust_m (2/10/2010)
lmu92 (2/6/2010)
Would you mind sharing what you've tried so far and where you got stuck?Did you have a look at the articles Jack referred to?
Sorry I've gone missing. ...
February 11, 2010 at 12:34 pm
How would you deal with a scenario where you'd have an (badly written) insert statement like:
INSERT INTO TargetTable
SELECT col1, col2, col3
FROM SourceTable
You won't find any column of your TargetTable...
February 10, 2010 at 1:56 pm
Please provide table def and some (fake) sample data (enough to show the effect you're faced with) so we have something to play with.
Your join syntax seems to be correct...
February 10, 2010 at 1:29 pm
Please search this site for string split functions or have a look at the Tally Table link in my signature which includes an efficient example.
February 10, 2010 at 1:11 pm
Your requirement is not clear at all.
Why would someone run a procedure to get empty result sets?
What you could do is to add a WHERE 1=2 clause to each of...
February 10, 2010 at 12:15 pm
GSquared (2/9/2010)
There isn't yet, but if you plan on storing the future document into a filestream table, and plan a backup for that, you should be able to use this...
February 9, 2010 at 12:24 pm
nigel. (2/9/2010)
lmu92 (2/8/2010)
nigel. (2/8/2010)
February 9, 2010 at 12:13 pm
Viewing 15 posts - 4,291 through 4,305 (of 5,504 total)