what you want to do here is use some customa ggregation:

a SUM(CASE statement can help you generate the counts in a single statement

something like this:

SELECT

COUNT(productid) AS Totalproduct,

SUM(CASE WHEN productname...

yeah the whole "exotic' naming convention for non traditional joins started back in 2007 with...

Jeff Moden (11/12/2013)

Very cool. I've not actually used the ACE drivers, yet...

here's my linked server example for a 64 bit folder full of text files that may help:

a couple of prerequisites:

install the AccessDatabaseEngine_x64.exe from microsoft:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

make sure you open an...

the trick here is what some people call an "exotic" join, where it's not joining on discrete values, but rather on the criteria (between dates) you are looking for.

Something like...

didn't find a single list from Microsoft, but i found this one on codeproject:

http://www.codeproject.com/Articles/39131/Global-Variables-in-SQL-Server

•@@CONNECTIONS

•@@MAX_CONNECTIONS

•@@CPU_BUSY

•@@ERROR

•@@IDENTITY

•@@IDLE

•@@IO_BUSY

•@@LANGID

•@@LANGUAGE

•@@MAXCHARLEN

•@@PACK_RECEIVED

•@@PACK_SENT

•@@PACKET_ERRORS

•@@ROWCOUNT ...

Dorthy Jeff Moden has a couple of posts on this, which i'd saved in the past:

here's the specific threads in question:

http://www.sqlservercentral.com/search/?q=%22Headerless+Ragged+Right%22

basically, he uses some dos commands to make sure the...

at my last job we had a similar situation, after one core issue boiled down to the client creating poorly written triggers, which broke the application's logic. against the user...

i can think of only a couple offthe top of my head:

TCP/IP / remote connections are not enabled by default.

no Dedicated Admin Connection is available by default.

depending on the...

here's my best guess based on your post's info:

i'm explicitly aliasing the target table, so it might make it a little clearer:

UPDATE MyTarget

SET MyTarget.updtbl_lat = i.infotbl_lat,

...

SQL Server Central currently has 103 videos on various SQL related subjects:

http://www.sqlservercentral.com/Articles/Video

add in the Stairways series on various SQl related paths, and you've got a great start right here on...

Pretty sure SQL server will...

it's not obvious, but if you look at the html source of some of your own email, the trick is referencing the content id(cid) of the attachment(s) that was included;...

well, you are only going to capture changes that occur in the future, after you've put some sort of auditing in place.

stuff that has already happened just plain is not...

well, i'd start with implicit users that come from windows groups:

select *

from master.sys.server_principals

where type_desc = 'WINDOWS_GROUP'

from there, for each name in the list, you can use a built...