Hector you can format your output from a select statement by using Convert and some of the date functions.

HTH

Mike

IF Object_ID('TempDB..#Test') > 0

 DROP TABLE #Test

CREATE TABLE [#Test]

(

[PkNumber] int IDENTITY (1, 1)...

Jeff you can insert ASCII codes into the print statement if you need special characters or want to generate a multi line statement.  Char(10) is the ASCII code for a...

Hi a question relating to your data. You have the Col name listed as AuditTimeStamp. Is this data of type TimeStamp or rowversion? If so the following from BOL maybe...

Edit Added code to remove Lunch times from appointment times..Never Ever tell the boss he can not take a lunch break.

Set based approach.

HTH

Mike

/*

Create a table with all possible appointments...

(My 2 cents worth)

Michelle, major changes in technology are very often complex and expensive. In many cases the cost are...

Perhaps the following will help others understand the complexity of your problem. Note these observations apply to US health care providers and may not be...

You can write a stored procedure that accepts parameters. You could also use dynamic SQL and create your SQL statements on the fly. The are...

Jeff, it depends on the type of trouble you want to shoot.

A table name such as "BrilliantUniqueLongLastingSuperHandyIndividualTable" could be confusing and transforming the table name...

I think that Jeff is on the right track. Using Ray's suggetion makes everyone's life easy. The purpose of a naming convention is to make it code understandable to humans (computers...

Remi in honor of your help on this post and others.. why just 2 days (the month is almost over). Perhaps this month and...

Meghana, How much of an inprovement did you see after making the changes?

Thanks

Mike

Additions to documentation from above post are marked in RED.

(Gee I just read my original post I have got to...

Hi this covers all cases including crossing a year boundry.

HTH

Mike

/*

Find all aniversity dates that will fall within the next 30 days

 Condiitons

 EE must have been employed with the company at least...

Slacker,  It sounds like you problem relates to establishing business rules (which have been ok’d by your legal department) rather than a problem that can be...

Thanks Rob

 Select Replace(Replace(Convert(Char(6),@thedate,109),'**','0'),'*','') 

Works great (FYI I cut and pasted from your original post ) 

Mike