Am I missing something in the code of the main stored procedure? There is an IF ELSE determining what data is being returned, but both segments of code after...

Revenant (12/5/2011)

---

SQLRNNR (12/5/2011)

---

Stefan Krzywicki (12/5/2011)

---

Evil Kraig F (12/5/2011)

---

The difference Gail is if you WERE American (or...

I would like to clarify my position a bit.

If you are hiring me for a database administrator or database developer position and tell me I will be working 40 to...

Oh, two things. Your code for your tables only works if people running it have the same databases and configurations as you do. Wouldn't run as is on...

TradeDateKey is defined as an integer, what and how is stored in this column?

mos-prog (12/4/2011)

---

Sorry, but i face one problem as it is my first time i deal with Database Mail,

when i try to send the Email it give me error with the...

bhaveshp.dba (12/2/2011)

---

Hello All,

How can I calculate last day of month?

I have two parameter in stored procedure

create procedure

(@year int,

@uptomonth)

as

begin

....................................

end

I want to calculate last day of the Month ....

based on...

mos-prog (12/4/2011)

---

Hi everybody,

I want to assign sql parameter called @myParam with many values returned from SQL statement like that:

declare @param text

set @param = select * from MyTable

but it give me...

You may have reached a tipping point with other indexes and that is why adding the new index helped.

One thing you may also want to to look at is the...

The two possibilities I see are blocking and network. You could run a server side trace to see if you can catch anything regarding blocking. You may also...

Perhaps the point that overtime drops of the radar should be moved up the pay scale. I have seen many places that require produce moves to occur late evenings...

slizam (12/3/2011)

---

here is the sample data from 2 tables;

Payphone

---------

PhoneNo MF6_TelMn ...

No...

Have you given us the complete error message? It looks quite short and seems to be missing some information.

I can see the report developers writing the stored procedures in their sandbox environments on their local boxes, but they probably shouldn't be the ones moving those into production. ...