Viewing 15 posts - 8,521 through 8,535 (of 8,760 total)
Try using a variable of the type "object" to retrieve the recordset. Then a variable of the same type as the column in a For Each loop.
😎
April 23, 2014 at 10:20 am
Matt Miller (#4) (4/23/2014)
I was going to go down the route of a CTE as well, but the OP mentioned 2005.
My bad, then the option is to nest it
😎
DECLARE @XML...
April 23, 2014 at 7:08 am
ChrisM@Work (4/23/2014)
I'd like to think OP will collect it from a list...
My point exactly!
😎
April 23, 2014 at 5:16 am
ChrisM@Work (4/23/2014)
hoseam (4/23/2014)
April 23, 2014 at 5:03 am
hoseam (4/23/2014)
April 23, 2014 at 4:40 am
hoseam (4/23/2014)
I'm planning to run everything inside the PROC:CREATE PROC (@Product_Id, @Fund_Id, @NewProduct_Id, @NewFund_Id, @TableName)
AS
BEGIN
END
that's just the shell. I'm still trying to get the inside code correctly.
A suggestion for...
April 23, 2014 at 4:21 am
Matt-1034261 (4/23/2014)
I have a table which has a couple of million records in it which relate to locations around the world.
I want to be able to do a search on...
April 23, 2014 at 3:52 am
ChrisM@Work (4/23/2014)
Eirikur Eiriksson (4/23/2014)
Is it this that you are looking for?😎
SELECT *INTO #MyTemp
FROM Sales.SalesOrderHeader;
SELECT *
FROM tempdb.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE N'#MyTemp%'
DROP TABLE #MyTemp;
Would you do it like this Eirikur or would...
April 23, 2014 at 3:28 am
Is it this that you are looking for?
😎
SELECT *
INTO #MyTemp
FROM Sales.SalesOrderHeader;
SELECT *
FROM tempdb.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE N'#MyTemp%'
DROP TABLE #MyTemp;
April 23, 2014 at 2:47 am
If you double click the Flat File Connection Manager to open the Flat File Connection Manager Editor and choose the Preview, what do you see in that column? You may...
April 23, 2014 at 2:40 am
SQLSteve (4/22/2014)
The failing data has ""DATA"" around it, where as all of the lines before are...
April 23, 2014 at 1:39 am
This is a very simple but effective approach using the nodes method to shred the XML
😎
DECLARE @XML XML = N'<applicant>
<summaryData>
<dataName>Age</dataName>
<dataValue>45</dataValue>
</summaryData>
<summaryData>
<dataName>LastName</dataName>
<dataValue>Jones</dataValue>
</summaryData>
<summaryData>
<dataName>NotThis</dataName>
<dataValue>Value</dataValue>
</summaryData>
</applicant>
<applicant>
<summaryData>
<dataName>Age</dataName>
<dataValue>48</dataValue>
</summaryData>
<summaryData>
<dataName>LastName</dataName>
<dataValue>Jones</dataValue>
</summaryData>
</applicant>';
DECLARE @APPLICANT TABLE
(
guid INT IDENTITY(1,1) NOT NULL
...
April 23, 2014 at 12:20 am
shashianireddy 30786 (4/22/2014)
how to reslove this errorMsg 468, Level 16, State 9, Line 7
Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
These two collations are...
April 22, 2014 at 11:19 pm
Check out this article, Merge multiple data sources with SQL Server Integration Services[/url] and the Stairway to Integration Services[/url] here on SSC.
😎
April 22, 2014 at 10:02 am
Viewing 15 posts - 8,521 through 8,535 (of 8,760 total)