There is not a platform called x32, there are x86 (32-bit) and x64 (64-bit). If you are installing local workstations on 32 bit platforms, use the x86 products. ...

You could try to execute the dynamic statement with FOR XML and handle it in an XML transformation. That way you're dealing with an XML document rather than a...

Yes, you will have a scalar computation versus a datatype conversion - slightly more expensive. This was more for load functions where rounding down to the nearest hour or...

skcadavre (8/19/2010)

---

Don't overly like.

Off the top of my head: -

DECLARE @caps VARCHAR(24),

@lower VARCHAR(25),

...

tommyh (8/19/2010)

---

Very complex passwords indead. However some observations

insert @tbl values(ascii('^'), 3)

Im not sure i would classify that as being benign. Since that char combined with another can create a single...

/* Get count of contact by app */

with ContactsByApp as (

select ApplNbr , count(*) as ContactCount

from Contacts

group by ApplNbr

)

/* get count of applications by contact count */

select

...