The SQL Search tool is in fact a really cool and free tool from redgate. It does not however accomplish what this person is trying to do. The SQL Search...

Did you notice that in your second query you are looking at a different column in the where clause?

What is the datatype of your OrderDate column? Some table definitions...

This kind of sounds like "can I move the sink from the bathroom to the kitchen without unhooking the lines"? You can install a new instance on the correct drive,...

I don't think that is possible. The report that is generated needs to be printable and if it is in a scollable region it is no longer printable. Somebody else...

Given that this is adding columns and such i will assume that this a one time use need. Just create your script in SSMS and then save it so you...

Sounds like you are asking if you can four logical checks within the same if statement and then do some logic that changes for each condition. You are correct in...

Go back and look at the whole thread. It has been explained in great detail with multiple scripts to run and test. Start on about 2 of the comments and...

This is the same thing I posted earlier but using your column and table names. 😀

select State, case when COUNT(txtJC) = 0 then null else COUNT(txtJC) end as StateCount

from #tblStates...

At the very least even if you stick with dynamic sql make it parameterized to help minimize the risk.

This is a stab in the dark given not much to go on. I just assume you want a list of all states with the count of detail records for...

ahh yes. I think I need more coffee. 😛

dur!!! I guess you pretty much had the same thing i did. Not sure why that wouldn't work.

something like

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TableNameHere]') AND type in (N'U'))

begin

you create trigger script here

end

you might also want to add...

Robert Frasca (9/8/2010)

---

All right, I confess. I don't get it. the subquery says where b GREATER THAN a not LESS THAN. As near as I can tell,...

Agreed excellent question. Took me a bit to understand the subtlety of it. Then just as I understood it, I discovered what was causing me to seriously scratch my head.

So...