I assume that "birthday" means just month and day, so my first thought is to add a computed column that just extracts the month and day in 'mmdd' format, then...

Great question! That's the kind of issue that would cause the loss of much hair if I'd have to figure it out in a production environment.

Pretty basic stuff. Here's a basic answer...

CREATE PROCEDURE MyProc

(@DId int,

@PID varchar(20) )

AS

SELECT RM.RName, RM.Logo, MST.PUrl, RM.HPUrl

FROM ...

Yes, there is a 'RunningValue' aggregate function that can be used for this.

You have 4 records for ClientID 102 in TableA, and 6 records for 102 in TableB. An inner join will match up each record in TableA with a corresponding record...

You can look for rows where there may be invalid dates by using the IsDate function in TSQL.

Select * from MyTable where IsDate(MyColumn) = 0

Note, however, that there are...

...

IF @vchtstsaddt IS NULL

BEGIN

SET @vchtstsaddt = NULL

END

Else

SET @vchtstsaddt = CONVERT(datetime, @vchtstsaddt)

...

This makes little or no sense. If the variable already is null, why set it to null?

On the other...

Not an answer, but a place to look...

Have you noticed if the Query Execution plan changes between the two cases -- the one where performance is good, and the one...

If that's what you need, you'll need to use dynamic SQL. You can create a dynamic PIVOT statement along the lines of what is in this article:

http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx

You can do something...

Lowell (6/24/2010)

---

wierd i got the same error, not sure if it is because of the reserved word SITE or not;

this passes the syntax check:

select cust_num,slsman,

SUM(CASE WHEN [site] = '11199'...

You can use the following to check for existence of the table:

if OBJECT_ID('tempDB..#temp','U') is not null

DROP TABLE #temp

Temp tables (created with #) are actually stored in the tempdb database, not in whatever database you're currently working in. I believe the sys.objects and sys.tables system views only look...

Looks like you have some info from the CodeProject site on using Regular Expressions or straight parsing algorithms to extract the text you're looking for. My recommendation would be to...

Nikhil,

What text exactly do you want to 'extract' from this? The entire database column? If that is the case, you could simply read the column data as text and write...

The C# console app is compiled into an .exe, isn't it? There is a job step type of "Operating System (CmdExec)" that will let you execute an .exe file within...