Hmmm,

I'll take that resounding silence as a "no - there's no better way" and "no, not many of us use this or have any experiences we want to share"...

I went...

No, it's not a solution but having looked quite a bit this appears to be the only workaround. I'm using a Script Task to come along afterwards and delete the...

Thanks everyone and WayneS in particular for reminding me of that possibility - I may well base my solution around that idea.

Crazy as it seems apparently this is the format the destination system wants. Let me explain further - at the moment I already have the three files produced by my...

I came across a handy way to make sure the syntax you use for this path is exactly right: open up package configurations and go through that wizard selecting the...

Yes, not a great question. It's testing whether we understand what a Cartesian product/cross join is but the answer depends on how many rows tblUsers has. I assumed from its...

Hi,

how about: SELECT SUM(CASE WHEN Targetdate BETWEEN DATEADD(day,-2,GETDATE()) and GETDATE() THEN 1 ELSE 0 END) Last2days,

COUNT(m.RID) [All Days]

FROM TASK_MANAGER m

JOIN TASK_ACCESS_USERS u ON m.RID = u.TaskID

WHERE u.AccessUserID =12 and m.[Status]=0

Hi,

This could be caused by the TEXTSIZE setting. Try: SELECT @@TEXTSIZE to see what you've got and adjust with SET TEXTSIZE x where x is the necessary length in bytes.

To understand this better Michael Coles has written a couple of excellent articles, the second of which is here: http://www.sqlservercentral.com/articles/Advanced+Querying/2829/

Hi,

There's actually nothing much wrong with your code logic-wise - there really are some grey areas as can be proved by putting 28th March 2010 2AM into the webpage you...

A somewhat ambiguous question again - as in even knowing the answer still left 2 answers as valid. If you leave the timeout box empty and click ok (SSRS 2008)...

I would go about it like this:

DECLARE @myTest bigint

SET @myTest = 9223372036854775807

SELECT @myTest & CAST(9151314442816847872 AS bigint)/

CAST(72057594037927936 AS bigint) Value1,

@myTest & CAST(72057593769492480 AS bigint)/

CAST(268435456 AS bigint) Value2,

@myTest & CAST(268435455 AS...

Hi,

I would create a stored procedure to do it based around this:

SELECT @sql = STUFF(

(

SELECT ' SELECT TID,SeatN,Posi,recGrp FROM dbo.' AS "text()",

[name] AS "text()",

' UNION ALL '

FROM sys.tables

WHERE [name] LIKE...

This question is decidedly woolly. Forget all the ifs and maybes about which client to use, which version of SQL or extra commands to include - you won't get far...

Hi,

You're not doing anything with the @doc variable; so even with SET CONCAT_NULL_YIELDS_NULL turned off you're getting:

SET '' = ( SELECT convert(xml, BulkColumn, 2)

FROM OPENROWSET ( BULK 'C:\Single.xml'...