Email Alerts
-
Trouble seeing source fields
SQL Server Development expert Greg Low offers a suggestion about invisible source fields. Ask the Expert
-
Varchar column errors
SQL Server Development expert Greg Low troubleshoots the error message, "The sum or average aggregate operation cannot take a varchar data type as an argument". Ask the Expert
-
Fixing bad coding within a SQL query
SQL Server Development expert Greg Low troubleshoots a programming issue within a SQL query. Ask the Expert
-
Resolving a query error
SQL Server Development expert Greg Low troubleshoots a WHERE clause error within a query. Ask the Expert
-
How and where to use CASE
Business Intelligence expert Eric Brown provides a helpful resource about when to use CASE and other SQL Server tools. Ask the Expert
-
Script to select specific record from a multiple-records table
Expert Greg Low explains how to select the correct records when they share an ID. Ask the Expert
-
A sample query for students with most classes
Expert Adam Machanic offers a sample query to find the names of the students enrolled in the largest number of classes. Ask the Expert
-
What is the difference between normal SQL and T-SQL?
Ask the Expert
-
Getting data from two servers using the same query
Greg Low explains how to use the same query to pick up data from two linked servers. Ask the Expert
-
Creating a script for row selection
Development expert Greg Low offers a script to select a row with the greater date, where item_key and pack_key are equal. Ask the Expert