Here is an example of using...

laurie-789651 (12/21/2012)

---

This is not a good idea. It's best to use an identity for auto-incrementing numbers.

This has been covered here quite recently, & the consensus seems to be that...

ncurran217 (12/21/2012)

---

I need to add a column to my existing table that counts up with every record added. But I want it to be something along these lines =...

There are two major points here.

1) Think about why the names can't be the same. Consider the following.

select * from Demo

exec Demo

Is the select referring to the proc or...

sqlfriends@sql.com (12/21/2012)

---

Hi Experts

I have the clarification in date comparision in previos dates , in One condition need To check Where my Typ_id is 01 and 02 Then date can...

The point that Laurie is making is that cursors are absolutely awful for performance. There are a few times when they are needed (maintenance scripts) but your example is not...

Bhuvnesh (12/20/2012)

---

Bhuvnesh (12/20/2012)

---

new learning...

That is the same thing you posted originally. It seems you want some help with...

David92595 (12/20/2012)

---

Basics: I'm running a SQL Server 2008 R2

I am trying to run a SQL job or maintenance plan on the startup (restart) of a SQL Server.

I’m trying to automate...

Try making this a SARGable predicate by removing the <> and replacing with > OR <

pr.price < 9999.99 OR pr.price > 9999.99

andrew gothard (12/20/2012)

---

I know this is not an answer to the question you've actually asked, but if your report is required to be accurate, remove the NOLOCK hints.

They're not a...

With the extremely limited amount of details nobody can do much here but speculate. It seems that having 3 or more tables all with the same basic data is overkill....

$w@t (12/19/2012)

---

Hi all

I have two stored procedures which return dynamic columns as result sets.

is there any way to combine both resultsets???????

after searching for solution i got to know that it...

Please don't cross post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1398784-1292-1.aspx

I would recommend to both you and Simon that you take a look at the link in my signature about splitting...