I was wondering about concurrency when I read your reply. I like the...

latingntlman (4/16/2013)

---

I need to pull records from a table and that would be pretty simple, however, the select statement needs to run as a sproc that passes a variable input...

Look at coalesce. That is exactly what it is intended for.

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

Many times using a cursor for this sort of thing seems like the only way to pull this off. sp_msforeachdb is just a cursor too. Neither of these approaches is...

That depends on what the stored proc does. Does the proc throw...

You can do whatever you want on your last day. 😀

As with everything in sql there are NO absolutes. If you want a portion of a process to...

liujchen 26197 (4/16/2013)

---

Thanks a lot for your reply!

Can you please guide me how to call a iTVF function

in the Select SQL I posted? Same syntax or I need

to use Cross...

kapil_kk (4/15/2013)

---

For the last query:

select COUNT(convert(int,NULL)) from #temp

It will return 0 because when you execute the query:

SELECT CONVERT(int,NULL) it will return NULL and as the return type of COUNT is...

Lowell (4/16/2013)

---

Sean Lange (4/16/2013)

---

you...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1442713-149-1.aspx

jimoa312 (4/16/2013)

---

Hi,

I'm new to SQL Server and I need to find out if the value 'Criminal' is stored in any of the Column/Fields within the database. Is there a...

liujchen 26197 (4/16/2013)

---

I have written another UDF to use while loop shown as below:

create function dbo.[ReplaceSplVarcharsBICD_test3] (@s varchar(8000)) returns varchar(8000)

with schemabinding

begin

if @s-2 is null

...

DiverKas (4/15/2013)

---

Lynn Pettis (4/15/2013)

---

Not true, using...

Well you could create your own IsAlpha. I would extend the version you found to at least include spaces and periods.

something like this might help you along.

declare @ScalarVal varchar(100) =...