prathibha_aviator (4/18/2013)

---

I know right but apply the same on below

IF (SELECT COALESCE((SELECT dI.[entry] FROM InitialData AS dI WITH(NOLOCK) WHERE dI.dept= 'Support'

...

Aha.. right. What I meant was...

select * from InitialData where [entry]='1'

works for me...

Am I missing something?

What's wrong with

select * from...

Why are you using <>1? If you want the condition to be true it needs to be dI.[Entry]=1. Otherwise it will always result in a null which coalesce converts to...

The job_num field should match the datatype in the source table. ie, it should be an int, and it should not be null, correct.

for your audit table you want...

Soooooooooooo... you're saying this code is production ready? :hehe:

Google UNPIVOT and then count aggregate.

ben.brugman (4/11/2013)

---

Dear reader,

It's not difficult to convince any manager; that storage in SQL-server would be a good idea. But because of lack of interaction software for the manager, most (if...

Have you tried looking at the end of the file to see what it's choking on in something like Notepad++ so you can see the characters?

Is SSMS right-click the table and select Create To Clipboard

Go to the alternate database and open a query

Paste the create statement and run it.

Now that you have the table just...

😀

I must have spent thirty seconds trying to scroll up and down to find the query the OP was talking about.

Lowell:

Thanks! I never thought of using a recursive CTE but that seems like the ticket to me if we stick with a straight SQL solution.

sturner:

I have to agree that...

Lowell?

Was there a piece missing where you convert it to a 32-bit format binary? ie. 001001001110010110001100...etc?

I stored your snippet for when I want to convert from ip to int and...

I hate it because I can't figure out how to setbase it into a single query but this will work for you.

declare @ip varchar(200)

declare @address varchar(200)

set @address = '24.55.187.203'

set @ip...

Here you go.

http://lmgtfy.com/?q=sql+server+2008+script+to+compare+databases