How about using NOT NULL in a WHERE?

I think it really depends a lot on the company. Also, if you have been at the same company for too long, you might have more marketable skills than...

I think we all have to swallow our pride and admit we don't and can't know everything - it is humbling when you can't answer an interview question - but...

REPLACE works too 😀

SELECT id,Nivel,REPLACE(A,'0','')A,REPLACE(B,'0','')B...

FROM @tblCron

What have you tried so far?

Are you running an old version of .NET (1.1)?

http://support.microsoft.com/kb/839174

Rao.V (10/21/2009)

---

– Get the current name of the SQL Server instance for later comparison.

SELECT @@servername

– Remove server from the list of known remote and linked servers on the local instance...

jdamian (3/21/2012)

---

So, it looks like you helped me out once again but I am unable to create this as a view. I get an error "Incorrect Syntax near the keyword...

So why...

If you can show me the structure of Shift_date and the table you want to join to, I can give you an example.

You already have the data stored in the Shift_table, so you shouldn't need another table or view - is there a join column in this other table that can be...

Thanks for the question. Even though I got it wrong, I learned a lot. 🙂

Is the query not used very often? If it is used often enough, you can monitor it using SQL Profiler - there's a duration field in a Standard...

opc.three (3/13/2012)

---

If you use SQL Agent, there is no need to introduce an additional programming domain into the call stack. Ditch xp_CmdShell and call bcp from a step with type...

hehe 😀