Viewing 15 posts - 1,561 through 1,575 (of 3,232 total)
Just some inside info on what's happening here. When you attempt to insert a '' into a datetime column, SQL Server must CAST the blank value to datetime. ...
October 24, 2008 at 9:30 am
Here's another approach w/o the PIVOT.
SET NOCOUNT ON
DECLARE @table1 TABLE(region_id int, region varchar(15))
INSERT INTO @Table1
SELECT 1, 'North East' UNION ALL
SELECT 2, 'South East' UNION ALL
SELECT 3, 'South West'
DECLARE @Table2...
October 23, 2008 at 1:52 pm
Well, first of all, everyone's opinion of rich differs. Making 150 K per year is far from rich. I do know that there are a couple of things...
October 21, 2008 at 9:44 am
Uh, you don't need a script task for this. This is an extremely simple operation to do. Use the ForEach Loop Container and place a File System Task...
October 8, 2008 at 5:21 pm
This is entirely too generic for anyone to help you out. We'll need some sort of table schema, sample data, and an example of what you are talking about...
October 8, 2008 at 4:00 pm
If it is NULL, why not just set it to the new XML value without going through the XML DML?
DECLARE @ProductBase TABLE (ID int IDENTITY(1,1), CrossSell xml)
INSERT INTO @ProductBase
DEFAULT VALUES
SELECT...
October 8, 2008 at 2:57 pm
Here's a link to the OP's other post on this same topic for reference, but let's use this current thread as the only one going forward.
Other thread:http://www.sqlservercentral.com/Forums/Topic582789-8-1.aspx
October 8, 2008 at 2:28 pm
Please don't cross post....
Let's continue this thread here:http://www.sqlservercentral.com/Forums/Topic582739-338-1.aspx
October 8, 2008 at 2:27 pm
Continuing the cross-posted thread from here: http://www.sqlservercentral.com/Forums/Topic582839-149-1.aspx#bm582875
anupamabr,
If when you select the XML value, it returns the word NULL, it means that there is no value. If you inserted...
October 8, 2008 at 2:04 pm
Please don't cross post.
Continue discussion HERE:
http://www.sqlservercentral.com/Forums/Topic582804-149-1.aspx
October 8, 2008 at 1:02 pm
You may try the Conditional Split or Multicast Data Flow Transformations (or a combination of both).
October 8, 2008 at 12:59 pm
The issues that everyone has raised here for correct placement of clustered indexes are all valid. It is a best practice to have a clustered index on all tables,...
October 8, 2008 at 12:52 pm
Letting you know that it is best practice to do that kind of work in the reporting tool is helping you. That is what those types of tools were...
October 8, 2008 at 12:40 pm
Well, the error means exactly what it says...you can't compare the XML data type like that. I see that you declare the XML variable, but never assign it a...
October 8, 2008 at 12:35 pm
That's what I thought. This kind of work is best done by the reporting tool, whether it be crystal, SSRS, or some other tool.
October 8, 2008 at 12:32 pm
Viewing 15 posts - 1,561 through 1,575 (of 3,232 total)