If you're data is still in the source systems, I would suggest ETL'ing them into tables in a single database. Then you could easily do a SQL query like...

Hi Johnny,

I'm not a replication expert, but I don't think there is a function like that. Typically when I have a need to drop and put back replication I...

I don't know for sure, but it looks like for the Import-CalendarCSV command you have to supply the value for the -EmailAddress parameter: so yes you would need to do...

I haven't done this, but I've used Powershell to get data out of Exchange Server into SQL Server, maybe Powershell would be a good way to go the other direction....

Sometimes when I have this issue, I start SQL Server Profiler and add the following events from the Errors and Warnings category: Exception and User Error Message. With these...

I knew this one based on experience.

Even if I hadn't had experience with SQL Azure and backups I still would have guessed "Feature not supported". This reason tends to...

Hi, one thing I would recommend is adding Data Analyst to the list of job search items. My last job was as a Data Analyst and I worked a...

Hey, good luck with the job. I got my start as a Data Analyst right after I graduated. I didn't have much database experience(one DB class and 3...

How about something like this?

SELECT

SUM(CASE WHEN void = 0 THEN 1 ELSE 0 END) countOfSuccess,

SUM(CASE WHEN void = 1 THEN 1 ELSE 0 END) countOfFailure

FROM test

Please post the error message. My guess is the data types of the column and the case are different?

I would google the syntax for creating tables and creating constraints. One good site for SQL Server syntax: http://msdn.microsoft.com/en-us

Once you get the syntax, get on SQL Server...

Not sure if this is best practice: At my job, the DBA has a dedicated windows account used for DBA tasks. It seems to work well, as it is...

Hi David, I'm glad you found the solution.

I second LutzM's crosstab suggestion as I find it easier than pivot as well. One tip for after you read the article he suggested if you go the crosstab...

I haven't had the same exact issue, but I've had an issue where a field started showing up as #ERROR on my SSRS report due to a data conversion issue...