It is not good advice to suggest that one should...

Compare your code with that posted...

kishore_gdk 24670 (3/17/2010)

---

actually My question is:

I have a database with over 200 tables, but without DELETE CASCADE. Is it possible to add DELETE CASCADE to all foreign-key definitions throught the...

It is a very common problem. That other thread has more to do with using the UNIQUEIDENTIFIER data type correctly, though.

The whole expression seems odd, since DATEPART returns an...

Yep...http://msdn.microsoft.com/en-us/library/ms180878.aspx#ODBCDatetimeFormat

SELECT Pvt.membername,

uniqueNum1 = Pvt.[1],

uniqueNum2 = Pvt.[2],

...

Linda Johanning (3/16/2010)

---

I've seen that error on SQL 2000 when the server was out of memory (don't recall if it was SQL Server or a linked server). This was...

Perhaps someone else will have the patience to extract some workable data and requirements from you.

Good luck!

puneet shadija (3/17/2010)

---

For getting records present in Table2 but not in Table1,

you need to join these two tables using left outer join as:

Select A.*

from Table2 A left...

For another option, see Jeff Moden's articles on pivots and cross-tabs:

Part One[/url]

Part Two[/url] (covers dynamic stuff)

Tips, Tricks, and Advice from the SQL Server Query Optimization Team: How to Read Statistics Profile

DECLARE @A TABLE (A INT NOT NULL);

DECLARE @b-2 TABLE (B INT NOT NULL);

DECLARE @C TABLE (C INT NOT NULL);

INSERT @A (A) VALUES (1);

INSERT @A (A) VALUES (2);

INSERT ...

Ok. Some example data and expected output would help.

Otherwise, I'd just say use an INSERT statement straight from your SELECT.

Cool. If the values in the variables are atypical, consider adding OPTION (RECOMPILE) to the statement. This will generate a new plan using the specific values in the...