also use the search feature here on SSC for "Base64"; there are a number of forum posts and submitted scripts to encode/decode;

here's the first of many i found:

BASE64 Encode and...

char 160 in a lot of fonts looks like a space; if you use it in an html document, multiple char(160)'s in a row get respected as valid chars to...

i think filenames/paths with spaces need to be wrapped in double quotes, right?

also, are you not CALLING the datapump? why is the DIR command in there?

exec master.dbo.xp_cmdshell '"C:\Program Files\Monarch Data...

i couldn't find a way to change it in the GUI, but when i looked in the registry, I found the spot to change it:

the key HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell has...

Rider i added a CASE in order by with two columns, and it seems to do exactly what you were after; am i missing anything?:

here's my results:

PART TYPE ...

ouch that changes things a bit;

can you please do a SELECT DISTINCT ColumnName From yourtable, so we can have the list of columnnames to normalize this data into? so...

Justin James (12/29/2009)

---

Thank you for the help Lowell. I'll make sure to include the appropriate SQL in my further posts.

One question I have about your SQL:

select ID/6 as REC, [ID]%...

Ray K (12/29/2009)

---

Just for your future reference -- if you post/present your data like this, you'll probably get faster responses! 🙂 (Basically, help us help you -- the less...

in TSQL, you could search for where any string begins by using the CHARINDEX function; it is the equivilent of vb INSTR function, or .NET's string.IndexOf("StringToFind")

if it is greater than...

i just googled "free system monitoring software" and found lots of stuff;

you want to watch for more than just the SQL server service being up or down; you've also got...

QML you did not answer any of the questions asking for clarification.

please, please read the comments a bit slower, and try to reply back to us to determine what you...

everything is working as expected; the user cannot directly insert/update/delete from the tables.

the assumption is that if you grant EXECUTE to a stored procedure, then the procedure can do whatever...

mahesh when i read BOL, it has this statement:

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

what user are you logged in as before you try to execute as 'dom'? are you in as sa or a sysadmin...

the error message is the clue: you can't select the row_id_no, because it is not part of the subquery in parenthesis.

remember what i said about aliases and parenthesis? that goes...

a subselect in parenthesis must have an alias;

formatting helps identiy the problem, too:

SELECT

max(DWT40034_BZL_VAT_TAX.ROW_ID_NO)

from

(

select

DWT40034_BZL_VAT_TAX.INTGRT_CNTRY_CD,

DWT40034_BZL_VAT_TAX.ORD,

...