riya_dave (7/19/2013)

---

hi

in my stored proc i have 3-4 while loop and i need to use different variable for it

i m having my code under begin and end. so is there...

Try these 3 queries and see what the results are.

select COUNT(*)

from table

where field is null

select COUNT(*)

from table

where field is not null

select COUNT(*)

from table

Sarah Johnston (7/19/2013)

---

On a query running from SQL 2012, reading a view on a 2005 server, I am unable to figure out how to evaluate null.

select * from table where...

PSB (7/19/2013)

---

Hi,

When I add the below line of code to my stored procedure, the performance becoems very poor. Is there any other way I can do i ?

AND CustNum...

Guras (7/19/2013)

---

I need to find the disk space estimation to create a new database with all the objects of the current databases ( without the data copied) ..for e.g. I...

The tables are the data. The ddl for tables, stored procs and views is next to nothing. What exactly are...

What do you...

But it...

Start here.

http://msdn.microsoft.com/en-us/library/ms179331.aspx

Grant Fritchey (7/19/2013)

---

Sean Lange (7/19/2013)

---

We have from time to time started heading in a bad direction. The good news is that there always seems to be a few people around...

Your post is extremely unclear but you are getting a 102 (Syntax error) because of your select statement at the end.

SELECT

(

[SELECT dateadd(dd,id_num,'20100101') FROM master..spt_values WHERE dateadd(dd,id_num,'20100101')<dateadd(yy,1,@date)],

[FundingDetails].[Total Commissioned Value]

)

FROM FundingDetails;

I can't...

Grant Fritchey (7/19/2013)

---

I was doing some research this morning and got sucked down a rabbit hole (it happens) and landed on a series of sites complaining about Stack Overflow and...

For the record this thread is 8 years old. 😛

Much like your other post, if you want help with tuning you need to give us enough information to work with. Follow the advice about what to post from the...

Is the email queue backed up again? I haven't received notifications all day today. Anybody else?