Create a table valued function that returns the delimited string as a column in a table. Join whatever table you are working on to this table (valued function) on the...

declare tmpcursor cursor for

select 'kill ' + convert(varchar, spid) as spid

from master..sysprocesses

where db_name(dbid) = @dbname

and spid <> @@spid

and dbid <> 0

Markus out of curiosity,...

In more detail, what exactly is the code 'supposed' to do ?

I think this is related to why I get faster results in SSMS when I export to text rather than to grid. The rendering engine plays a part in the...

Thanks for the feedback, glad this worked out for you.

CELKO (12/19/2014)

---

We are migrating data from old DB2 systems to sql server 2012, the DATE FORMAT in those systems is in decimal format with 7 digits. CYYMMDD format. I...

Hi Orlando,

Hmm, I guess I am not clear on what you mean... I just saw that unicode decimal 253 is the...

Agreed, its not hard on my eyes either. I am trying to get into the mind of someone that has not seen this syntax before. It is not that difficult...

jshuter (12/17/2014)

---

I understand the need to use SQL when doing SQL but a little looping wont kill ya 🙂

I'd still do something like the following

declare @i int =...

Under SSMS> Server Objects, >

there is a Backup Devices folder. Here you can easily create a .bak file and easily find it later as well through here. You can point...

Statistically speaking you want the first quartile, so borrowing on Matt's solution I would just shift a few things to make it intuitive ...

with MYcte as (

selectMAINGROUP,vALUE, NTILE(4) OVER...

I find in these situation I save a lot of time by dropping the source and creating a new one. If I had SQL coded I copy it ahead of...

0 means 0 , NULL means unknown. They are not the same.

One approach if you do not want to have nulls in your table is to have a "magic"...

mitesh.temre (12/17/2014)

---

lvbntapasvi (9/6/2014)

---

Hello All,

I am new to SSIS, and have started using it from the past 3 weeks. I have a task where in I am supposed to access the...

I think...