varunkum (12/21/2010)

---

Last run date is when the report was run lastly. Suppose if yesterday i opened...

You can't use "if" in a SELECT

select CASE WHEN...

Sorry, I just noticed that I basically repeated what Lamprey13 had already said :doze:

My apologies to all...

Please check to see if a TRIGGER has been applied to the table - it seems likely.

I have to agree that this is a PITA, but if you are truly stuck with it and don't want to give up just because it's hard....then...

declare @testFieldType table(fieldId int,...

I also don't care that much about portability - whenever I write a query it is on SQL Server and AFAIK there is no plan to remove GETDATE().

I also don't...

+1 for filtering in the Object Explorer of SSMS

+1 for partition functions

+1 for execution plans (both graphical and xml)

New ones - not mentioned so far.

XQUERY - Processing xml has...

Agreed - I was ignoring the lack...

WayneS (12/16/2010)

---

What are your preferences for VM machines - VMWare or VirtualPC?

I've been using VMWare for years (and am happy with it), but to install a 64-bit Windows 7 and...

WayneS (12/16/2010)

---

IF OBJECT_ID('tempdb..#Test') IS NOT NULL DROP TABLE #Test;

CREATE TABLE #Test (RowID INT PRIMARY KEY CLUSTERED);

;WITH

TENS (N) AS (SELECT 0 UNION ALL SELECT 0 UNION...

If you are a sysadmin, sql will ignore your request to set a default schema on your login and use "dbo"...does that sound like what is happening?

I think "That's mighty fine code, but let me show you how to do it better..." should be one.

Is strAllRows a typo?

It's still a bit of a strange request as your backup table would need to change to accommodate these new columns wouldn't it?

And how often are you planning on...

That is a strange request - if you don't want to manually enter all the column names, just open the object explorer, find your table and drag the "Columns"...