PiMané (10/2/2012)

---

Hi,

If I have a stored procedure that only checks if a customer exists (simple case) it's better to use an OUTPUT parameter or return a data row?

When returning single...

Wait for JC to state that "We don't use IDENTITY, Cobol-like monster from 50's" :hehe:

The only place where I would agree on legitimate use of GUID's for PK, would be...

...

I really appreciate your help. My reasoning was that do I have to repeat all the "Select Union" statements for all the rows that i have?

I could be missing something!...

CELKO (10/2/2012)

...

Why would anyone create a local variable (like we did in 1950's assembly languages) to hold the results of an expression. We just use the expression itself in declarative...

It depends, but usually BIGINT is better.

Another question, related to keys... If a table uses Id as...

oscarooko (10/2/2012)

---

Eugene Elutin (10/2/2012)

---

Use XML FOR PATH method (it most likely will give you the best performance for T-SQL implementation):

declare @Table1 table (EmailAddress varchar(20), Msg varchar(20))

insert @Table1

...

Question to OP: Can the name change? - If yes, you cannot partition by name.

Numbers for MartialStatus and EmploymentStatus can change from higher to lower, therefore you cannot really use...

You will not get different query execution plan per user if you don't specify schema.

Unless your system is designed in a such way (it's very rare case actually) that one...

Use XML FOR PATH method (it most likely will give you the best performance for T-SQL implementation):

declare @Table1 table (EmailAddress varchar(20), Msg varchar(20))

insert @Table1

...

Jeff Moden (10/1/2012)

---

Eugene Elutin (10/1/2012)

---

A couple of us just went through all of this on another thread a couple of months ago and the LIKE expressions blew the doors off...

So looks like that dbname.dbo.Y_name is not accessible from connection you are trying to execute your procedures. Check the name spelling as well.

...

I would like to display all data from deal_2 (table 1) and price_2 (table_2) in date order. I assumed the left join clause would be easy to implement with...

The question...

From what you posted I can tell you that you don't need to check for NULLs in columns you INNER JOIN on. So the following query will produce exactly...

I hate loops as well, but it will be ok if used for splitting a...