Constantly posting new threads on the same topic isn't going to get you better answers.

Jeff Moden (2/15/2013)

---

I have to ask... if you're not using the DATE or...

Could use the DDL for the tables, index definitions, sample data, expected results, and of course the actual execution plans for the two queries.

Other than that, all you may get...

This perhaps?

-- Delete from Table2 must run first

DELETE FROM

dbo.Table2 t2

WHERE

t2.TimeStampCol < @CutOffDateTime;

-- Then run delete from Table2

DELETE FROM

dbo.Table1...

Perhaps this?

if exists(select 1 from tempdb.sys.objects where object_id = object_id('tempdb..#TempTable'))

DROP TABLE #TempTable;

CREATE TABLE #TempTable(

[Customer] VARCHAR(50) NOT NULL,

[Status] INT...

I think this is not quite correct:

Database context will not be changed while executing EXECUTE statements. The reason is changes in database context last only until the end of the...

I'd do it this way and use it in a CROSS APPLY in the FROM clause:

create function dbo.RemoveVowels(

@pString varchar(max)

)

returns table

as

return (select replace(replace(replace(replace(replace(replace(@pString,'Y',''),'U',''),'O',''),'I',''),'E',''),'A','') NoVowels);

go

I'd like to make a suggestion. Developers really need to stop using this notation for subtracting days from a date: @datevariable - 2. Really should use the DATEADD...

You get what you pay for.

This is a free website and the people who volunteer to answer questions here do so on there own time....

In a full and differential backup enough of the transaction log is backed up to ensure a consistent database upon restore. The SQL backup does not pick and choose...

All I am going to say is this, stop trying to circumvent the DBA. His (or her) job...

Jan Van der Eecken (2/15/2013)

---

Mark, did you copy and paste the error message directly from SSMS? If yes, then they are indeed different. Just look closely, the one is Latin1_General_CI_AS,...

ScottPletcher (2/14/2013)

---

That's a significant change!

In order, here's a quick list of the most important things to do first:

1) Make sure the DBA role will fit you. As a developer,...

Unfortunately, we can't see what you see so it is hard to know what to tell you.

scribesjeff (2/14/2013)

---

Hi,

I'm new to T-SQL and need a little help with this query.

I need to convert or CAST and INT into a Char inside a case stament. I'm going to...