You can also find missing dates with a Numbers table more easily than is outlined in the article.

To set up the test:

create table MissingDates (

Date datetime primary key)

go

insert into dbo.missingdates(date)

select...

Yet again, I have to say this is clever, but a Numbers table is better.

Method in the article, run against a table with 9989 rows:

----------------

SQL Server parse and compile time:...

I'm assuming all of this is to create a logging function. You'll run it on a schedule, and thus have a sort of picture of the state of the...

If that does what you need, you might want to try replacing the exec command with sp_executeSQL. It works better, and can take input parameters and such. Books...

It's been so long since I used it, I forgot that exec doesn't like string functions. Try this:

declare @date datetime, @cmd varchar(1000)

set @date = getdate()

set @cmd = 'SELECT *...

Please copy and paste your code into the forum, and the error message you get.

The foreign key enforces the data at a level below the proc.

This means that, if someone tries to delete data from the primary table, without a foreign key constraint, it...

Use:

declare @date datetime

set @date = getdate()

exec ('SELECT * INTO [table_Backup_'+cast(@date as varchar(100))+'] FROM table' )

First, you need to declare @date as datetime, not timestamp. (Look up timestamp in...

create table #Temp (

ID int identity primary key,

FromID int,

ToID int)

insert into #temp (fromid, toid)

select *

from

(select 1, 1000000 union all

select 1000001, 2000000 union all

select 2000001, 3000000 union all) -- however many...

The only way I know to do what you're asking is to move the second table variable to a separate proc, and call that proc with input parameters from the...

There was a very good article recently on the front page of this site about running totals, and being able to split them into running sub-totals. Check that. ...

Truncating will also help prevent excessive log growth.

Not sure why it wouldn't appear there on its own.

To fix it, you can right-click it in Program Files, select "Create Shortcut", then drag the shortcut to your start menu.

;with

Rep1 (Prod, Acct, TC, SubmitRep1, Percent1, ID, Seq) as

(select Prod, Acct, TC, SubmitRep1, Percent1,

row_number() over (order by Prod, Acct, TC, SubmitRep1, Percent1, 1)

from dbo.tbl_CYProcessedSales T1

WHERE

Proj IN (100,200)

AND Percent1...

Does it need to be columns, or would a list (with commas or some such) work?

Is there a reason to have SQL do this, and not to have the front...