Here is a tool that I like to use to help with formatting. It seems to copy and paste ok into SSMS. I don't always like the output,...

There is a trick to avoid the dynamic sql by using xml.

http://www.mssqltips.com/tip.asp?tip=1568

You can do something like this.

Declare @Date datetime

Set @Date = getdate()

Select @Date -

CASE datename(weekday,@Date)

...

In order to use the default you cannot supply a value to the column. It is converting the '' to the 1900 date and not using the default.

Try this.

create...

Try this.

Select Name FileNme, size * 8/1024.0 Size_MB, fileproperty(Name,'SpaceUsed') * 8/1024.0 SpaceUsed_MB from sysfiles

Here is another way. You cannot use a variable name in the USE Statement.

Declare @sql varchar(max)

Set @sql = ''

select @sql = 'Select ''' +...

Try this.

Create Table #Tmp (dbname sysname, tablename sysname)

go

sp_msforeachdb 'use ?; Insert into #tmp select ''?'' dbname, name from sys.tables'

Select * from #Tmp

Drop Table #Tmp

If you need to make sure you don't cut off the trailing spaces, you can concatenate a character to the end and then subtract 1.

Declare @test-2 nchar(4)

Set

Be careful using Datalength because unicode takes up two spots. The following results in a length of 6.

Declare @test-2 nvarchar(3)

Set @test-2 = '123'

Select Datalength(@test)

Try this. You have to join all the tables seperately.

SELECT e.Migration,

ed.Migration

FROM ptEncounter e

INNER JOIN...

I don't know of a function in SQL that will format a number that way. I generally do something like this.

Declare @i int

Set @i = 23

Select Right('0000' + Cast(@i...

Here is the sample code to create the test tables. I seem to be getting the results as expected. Try running the entire code sample and see if...

Try this.

SELECT

...

You can use a common table expression to store the agentid with the max date and then join it back to the original table to limit the results.

create table #a

(ID...

True. I guess it depends on what you are looking for. Most of what is done behind the scenes can be accomplished using scripts, which there are more than...