DBA12345 (4/17/2013)

---

Hi Thanks for your reply...I am not getting the result with your query. I have written like below.

for the belwo proc few folks in this same forum suggesting me...

Brandie Tarvin (4/17/2013)

---

So I have this ridiculous thought of doing a series of articles for my blog on how to build a SQL Server database for a comic book collection.

What...

Steve Jones - SSC Editor (4/17/2013)

---

Peter Schott (4/17/2013)

---

fundpc (4/16/2013)

---

I say it’s a sad commentary that we now are expected to “post” so that lazy HR types can scan our...

Not sure what you are expecting but running the following all I see in the output is 1:00 PM to 2:00 PM which corresponds to the LunchStart and LunchEnd for...

Unfortunately, without seeing the the DDL for the view and the underlying table(s) and their indexes, plus how the view is being called I don't see how much more we...

In this case the % is the modulo operator. ...

Cadavre (4/17/2013)

---

Lynn Pettis (4/17/2013)

---

Two things. One, why the cross applies here. I don't think they are really needed. Two, the OP did say to treat NULL using...

Sure, once you post your code. Of course once you do that we may ask for more, but it is a start.

jhager (4/17/2013)

---

Thanks...I've been able to use sp_executesql to execute SELECT, INSERT, etc., but NOT execute a procedure. Maybe it's not possible because of the parameter scope.

I appreciate the response, though.

~...

The following is from MSDN for SQL Server 2012. Please read the information at the top of the page.

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

I just want you to be aware that this feature is...

Cadavre (4/17/2013)

---

Why are you storing dates as INT? To get the number of days difference, you're going to need to convert to DATE.

Try something like this: -

IF OBJECT_ID('abc') IS NOT...

I had a copy/paste issue, here is updated code:

CREATE TABLE abc

(gg_key int,

fg_sta_key int,

fg_eff_dt_key int,

fg_end_dt_key int,

fg_seq_nbr int)

insert into abc values(19925,2,20130128,20130128,1)

insert into abc values (19925,8,20130128,20130128,2)

insert into abc values(19925,1,20130129,20130416,3)

insert into abc values...

jhager (4/17/2013)

---

While checking our production plan cache, I noticed that over half of the entries were like the following:

exec mt_amstask7 'AMS','78609072','1045458320','20130417 05:05','AMH','20130417 05:07','U'

exec mt_amstask7 'AMS','78609072','1045458304','20130417 05:05','AMH','20130417 05:07','U'

exec mt_amstask7 'AMS','78609072','1045458320','20130417 05:05','AMH','20130417...

Here is your sample data and some code. You tell us what the problem is:

CREATE TABLE abc

(gg_key int,

fg_sta_key int,

fg_eff_dt_key int,

fg_end_dt_key int,

fg_seq_nbr int)

insert into abc values(19925,2,20130128,20130128,1)

insert into abc values...

Are the tables partitioned in any way?