Can you post your xml string?

You don't have to go, find and parse yourself, when working with XML you can use xml functions to get specific node values.

You can query the sys.sysdepends view, like:

SELECT object_name(id) as MainObj, object_name(depid) as DependObj FROM sys.sysdepends

... you can join sys.sysobjects view to get more info, like:

SELECT object_name(d.id) as MainObj, o1.type 'MainObjType',...

You need CASE with ORDER BY clause, try this:

with cte as (

select distinct

State_Code,

case when State_Code=' ' then 'Unknown'

else State_Code

end State_Code2,

1 as 'State_Code1'

from Dim_Prop_Geo_T

union

select 'All' as State_Code,

'All' ,

0 as...

Yes, the bad thing is you have 2000, otherwise in 2005 & 2008 its would be easy to do in a single query but still with a tricky logic.

Right now...

How about this:

select datename(M,convert(varchar,months)+'/01/2010') as days

from (select 1 as months union

select 2 as months union

select 3 as months union

select 4 as months union

select 5 as months union

select 6 as months...

Following Link may help: http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/444e30ec-38cf-4c46-939a-3fc4e194017d/

Following post may help: http://sqlwithmanoj.wordpress.com/category/excel/

Forget Man & Car... what about when you have Customers & Products

Customer (custtid, ...)

Orders (orderid, custid, prodid, ...)

Products (prod id, ...)

Orders sits b/w Customer & Products as one customer can...

Thanks Gail.

But In an interview I was asked, how can I create a PK column without any index?

I responded that this is not possible as SQL Server automatically creates Clustered...

If I create a primary key on a column then it automatically creates a Clustered Index on it.

How can I create a PK without Clustered index?

This may help: http://sqlwithmanoj.com/2009/11/10/deploy-an-ssis-package-add-it-to-a-job/[/url]

Hey!

I also use Advantage CRM, which version do you use?

Which company you are in?

-MP

Hi,

You can add a File System Task at the end of the flow.

Create 2 different variables for Source & Destination file.

Like for Destination excel file you can set the property...