Hi Gabriel

So if the performance of your UNION is well, I would just avoid the copy-pasting:

DECLARE @month DATETIME

SET @month = DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0)

DECLARE @sql VARCHAR(MAX)

SELECT @sql...

Dang! 5 Seconds! 😉

Hi

Two questions:

* Which version of SQL Server do you use?

* Could you please attach the XML as file or mask it? 😀

Greets

Flo

Powershell? Wish you the best :-), it can do almost everything, but the syntax is just ugly in my opinion...

Greets

Flo

I'm using a logging procedure instead of PRINT function. This has two advantages:

* You can use arguments to be used in a formatted string. The arguments are SQL_VARIANT (maybe the...

AMJ (3/27/2009)

---

I am giving you the exact scenario -

1. I have a tab control with 3 tabs on it.

2. 1'st tab has a user interface for record filtering.

3. 2'nd...

Hi

The expression "//CommentHistory/" is not a valid XPath expression 😉

You can change the...

Try this:

DECLARE @xml XML

SET @xml = '<CommentHistory>

<Comment AddedOn="03/26/2009" AddedBy="testuser">This is a test</Comment>

</CommentHistory>'

select

ref.value('./@AddedBy', 'nvarchar(30)') as addedby,

ref.value('./@AddedOn', 'nvarchar(30)') as addedon,

ref.value('./text()[1]', 'nvarchar(50)') as data

from

@xml.nodes('//CommentHistory/Comment')R(ref)

Greets

Flo

Hi

Could you please attach your sample XML as TXT file? 😉

Thanks

Flo

Hi Uma

Seems to be an issue within SQL Server 2005 which should be fixed with service pack. See the following link:

http://bug.gd/search/details/90710/the-incoming-tabular-data-stream-tds-protocol-stream-is-incorrect-the-stream-ended-unexpectedly

Which refers to:

http://support.microsoft.com/default.aspx?scid=kb;en-us;959025&sd=rss&spid=2855

Good luck

Flo

Hi

SQL Server Express Editions don't contain the SQL Server Agent. See:

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

Which substitute? It depends on your requirements. If you need to schedule simple tasks have a look to the windows...

Hi

I think the problem is that nobody can help you since you don't specify your business case a little more.

The most simple (and certainly not helpful) answer would be:

Schedule your...

a2zwd (3/26/2009)

---

Hi,

I have a table in my database with the following fields.

Location INT (FK)

Specialty INT(FK)

Sex VARCHAR(1)

Availability VARCHAR [ 1-Monday, 2-Tue] in the format (1, 5, 6)

DocumentFilename VARCHAR

I want to do...

Hi

I don't think that a database trigger would affect the operative performance of your system.

Greets

Flo

Hi Ratheesh

Sorry, I have absolutely no idea about DB2.

Good luck

Flo