Ok so when I create a snapshot of a regular standalone database and then delete a record in that database then the change will be at the database and if...

I'm stupid :w00t:

It's Ctrl + R

Found it by using the menus LOL

you are a genius.

i forgot my code won't be using an index with that datepart.

thanks!

I'm dumb, I made a typo and I meant dataset LOL. Sorry.

I ended up making multiple datasets, one for each report item.

Hey guys thanks for clarifying this, especially craig and ramkumar.

I didn't expect the author of the book to find my post and reply---that was cool. 😀

Craig Farrell (12/13/2010)

SQL Iron Chef (12/13/2010)

In my environment I've seen:

1. WHERE ISNULL(burgertype, 'Bison Burger') <> 'Cheese Burger'

2. WHERE (burgertype IS NOT NULL OR burgertype <> 'Cheese Burger'

I'm just curious if...

SQL Iron Chef (12/13/2010)

In my environment I've seen:

1. WHERE ISNULL(burgertype, 'Bison Burger') <> 'Cheese Burger'

2. WHERE (burgertype IS NOT NULL OR burgertype <> 'Cheese Burger'

I'm just curious if there is...

Chuck Norris doesn’t need Try-Catch, exceptions are too afraid to raise.

Houston, TX. The Energy and Humidity Capital of the World

Thanks Eric, I got the same response when Googling so I tried to do it locally logged on to the server and same error happened

I was able to figure this out about a week ago and wanted to share my experience.

1. I basically used a table layout with fixed times on the columns (I...

Just a guess, Try the DAC.

http://www.mssqltips.com/tip.asp?tip=1005

Thanks Wayne. I didn't know you could pass parameters via URL.

I actually just found out from the network admin that this was coming from microsoft system center.

man i was digging around all morning and wondering how i even got this...

Yes