yep you are missing the #1 fix to SQL injection: using parameters instead.

generally, you never want to change users data. using it for comparisons, maybe...but even then, you want to...

this was interesting...

not sure if you want to get the data as rows or columns, you might need to pivot this data if you need it as columns, see what...

ugg; except for building a presentation string for binary,

i always leave my values as integers for data manipulation...very easy to test each column for whatever it represents them.

any chance...

does a SKU have a standard length, like 6 characters?

do you have a lookup table of all skus so you could look up whether it is valid before or after...

well, first, a .cmd file is just the renamed verison of a .bat file...something you might typically call via command line / xp_CmdShell (if that is even enabled)

that .cmd...

there's another function for the UTC date you cvan use: GETUTCDATE()

select (UTCOccurrenceDateTime >= DATEADD(day, DATEDIFF(day, 0, GETUTCDATE()), 0))

i'm guessing someone may have installed the full version of Visual Studio, which would supercede the BIDS version...could that be true?

in that case, there's nothing to do...just open visual studio...

i tried to help and started scripting, but you simply didn't provide enough data.

you originally posted sample data with two columns...i had to dig thru your post to figure out...

try this: maybe the login is a sysadmin:

you'll need to change the name of the login to your specific login/sql user in question:

EXECUTE AS LOGIN='ThatSpecificSQLUser';

--the auditing snippet below...

Dave Ballantyne (1/4/2012)

---

Sounds to me like an unindexed foreign key lookup, trigger activity, blocking or indexed views.

Take a look at the plan and the active processes to see if you...

sysobjects :

you can either use SCHEMA_NAME(sys.objects.

object_id) from sys.objects

OR

JOIN sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id)

DavidL (1/4/2012)

---

Lowell: I will experiment a little with that. However, when I run your query as you've written it, the copy a definition into SSMS it comes through...

via TSQL, it's one of those really difficult things to do on your own.

Like Gus said, all the data is out there in the sys.tables/sys.columns metadata views, but it's up...

something like this should do it in a single statement;

see if this does what you would like:

With FNames AS (

select distinct firstname from Customer),

LNames AS (

select distinct lastname from Customer),

Randomized...

David, i think it has to do with CHAR(10) vs CHAR(13) + CHAR(10) as the line terminator.

SSMS will show you the definition the "right" way, regarless of the terminator, but...