it looks to me that you are merging into GiftCard, and not GiftCard_Transactions. the balance does not belong int he Gift Card table.

there's only one card, heck i'd think it...

what you are looking for is a SUM(CASE construct like this:

/*

Cust TotalCount TrueCount FalseCount

Na 2 2 ...

that is correct. there are no tests related to 2008-related certifications to take anymore, but there's it's new successors for the 2012 level platform.

they were superceded and replaced by...

i seem to remember that xp_cmdshell is limited to a single set of double quotes, right?

so "\path with spaces\oldname" "\path with spacesewname" might return an error?

global temp tables still get dropped when there are no more sessions at all, i believe.

from msdn i think, in my notes but not attributed:

a global temp table exists for...

a lot of the time, the GUI might not show you all possible datasets...you sometimes have to "KNOW" that a database exists.

you can run sp_tables_ex in SSMS to get details...

Thanks Anthony! I added that to my snippets; damn i love the teamwork here!

i use this to enumerate all members of all groups on a given server. then you can see when someone shows up in multiple groups.

IF OBJECT_ID('[tempdb].[dbo].[#TMP]') IS NOT NULL

DROP...

body is defined as nvarchar(max), so it's likely that you are getting some implicit conversions to nvarchar(4000) when you are building your htmlbody.

can you show the code that builds that?

that's...

i was always under the impression that to downgrade, you have to uninstall and reinstall.

especially master and the hidden resource databases, which cannot be restored to any lower version service...

at my last place where we supported Oracle and SQL for an applications RDBMS, we had a specific set of rules to map equivalents structures at a table level. it...

typically, you look at at a specific table, and decide which specific columns need to be encrypted, either because they contain personally identifying information, health information, or sensitive info...

after the bcp is created, you can call 7za.exe(the command line version of 7zip) to zip the file.

if you call it from xp_cmdshell, you are limited to one...

was this a question, or were you pointing folks to the solution to an issue you encountered?

we'd need more details to really help.

my research implies it's due to bad logic in the procedure:

when i googled "sql error 3621"

this link implied that the error was returned...