I was giving some time for the experts to chime in since I do not have a definitive answer for you...but since you reposted I'll jump in...

Your WHERE clause tolerates...

Martin Stephenson (3/14/2011)

---

Do i ask for multiple LUNs pretending that there is a C:\ (OS), E:\ (temp), F:\ (Data) and G:\ (log) disk structure or do I just present a...

I am a bit confused as to what you're now asking. My solution was based on using OPENXML...it lokos like somewhere along the line though you switched to using CROSS...

You can achieve this by using the Derived Column Component to add a blank column to your data set and then using a "Transformation Script Component" to populate the...

USE msdb

GO

DECLARE @proc_name SYSNAME = 'stored_procedure_name' ;

SELECT *

FROM dbo.sysjobsteps

WHERE command LIKE '%' + @proc_name + '%' ;

This should get you there:

DECLARE @idoc INT ;

DECLARE @xml XML = N'

<views>

<view viewName="test_view" viewSequence="1" viewVersion="2.0" viewitem="US" viewStart="2011/02/16 15:00:56:056" viewEnd="2011/02/16 15:00:57:057" viewDuration="00:00:00.5468750">

<viewEvents>

...

TheGrem (3/14/2011)

---

Hi All,

I desperately need help.

I have created a stored proc that retrieves my data correctly from a table. I need to be able to access this data...

Here is some free Video content from some of the best in the biz:

Policy-Based Management

Policy-Based Management Demo

The Import Export Wizard will help you do a simple 'source to destination' data copy, hence the lack of transformation support. It's a shortcut to create a package very similar...

spin (3/14/2011)

---

great, thanks.

I see your point and def don't want to start rolling back transactions. Am i right in thinking that i don't need to worry about this in 2005...

This plus the info from ALZDBA should provide the tools to reach your solution.

DECLARE @ThisDate DATETIME = GETDATE() ;

SELECT

DATEADD(hh, DATEDIFF(hh,...

As an aside, if you need help with SQL 2005 it's best to post in the SQL 2005 Forums otherwise you may get 2008-specific responses.

For you particular issue, and this...

Not ideal but I can work with that for DDL...can you please provide some test data?

Please have a look a this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

I would like to help...kindly post the DDL for your tables and DML to generate some useful test data.

Please post DDL and some DML to create test data for your tables:

asap_email_listTrain

TRAIN..SALES.DEL

TRAIN..MISC.ZIP2ZONE

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D