Do you have to store the HTML tags in the first place would be my question???

I had a similar problem, but I used regular expressions in the frontend to strip...

No ... not your end .... Same here, too!!!

IF  (expression)

BEGIN

 BEGIN TRANSACTION

 ... some code ...

 COMMIT TRANSACTION

END

ELSE

BEGIN

 BEGIN TRANSACTION

 ... some code ...

 COMMIT TRANSACTION

END

this help???

retreiving dateparts:

SELECT DATEPART (month, getdate())   -- you can use day or year accordingly where needed

The above post will give you a datestring. To get this into s datetime variable use:

SELECT CONVERT(datetime,...

If you use linkservers (enabling you to use the long prefix syntax server.db.owner.table) then make sure they both have the same sorting options, otherwise you may get an error when...

Hi Frank

If you are using Enterprise Manager, then you can generate the Creation Scripts for the Stored Procedures. This script can then be carried out on the new server and...

Hi Elias

Have you ever let the procedure come to an end??? I had a similar problem lining SQL7 & SQL2000 - A Query that was executed locally with a replica...

Hi there...

We are using .NET (VB .NET) frontend applications to analyse Data from SQLServer 2000. We use stored procedures where we can.

First of all, when using stored procedures through the Command...

You can write a function upfront in VB .NET. There you can get the date and split it into day, month, year (See Documentation VB .NET for Date manipulation) and rebuild...

Why the dynamic SQL???

Why not just use the Statement as is? Why build it dynamically in this case?

SELECT * FROM ggg_emp 

WHERE CONVERT(varchar(10),date_join,101)

BETWEEN CONVERT(varchar(10),@start_date-1,101)

AND CONVERT(varchar(10),@end_Date+1,101)

just a thought...

If you Select the above statement into a temp table, you can then use the following Statement on the temptable (changing the names respectively of course!) - I named my...

Here we go again...

I thought this site is about people helping each other out with practical advice????

Has this changed???

Trick question's are okay - but this one wasn't even a...

How about

SELECT CONVERT(datetime,'10/10/2003',103)

where 103 refers to the format of the date you recieve, can be substituted with a different number if you need a different format ... See BOL...

Using the same table as in the above post ... How about the following?

INSERT INTO #TABLE_REPORTS

SELECT  user_id,  'report_a',  'first month report'

FROM #TABLE_REPORTS

WHERE user_id NOT IN

 (SELECT user_id

  FROM...