SQL Server Help
Hi all, I am running into a little bit of a problem. I need to insert records with a stored procedure into a table based on the information selected. From the info selected, it decides what table to insert it into.  Example: Select top 1 SerialNo from dbo.Serial –returns ‘ASEEADL1234567′ based on the 8th letter [...]

Answer Question   |  March 31, 2012  8:36 PM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures

SQLCMD does not create a log file
I have several SQL update/delete statements I run during a payroll cycle. When I run a SQL that does not have any records that meet the selection criteria, I do not get a log created. I can run the same SQL in SQLServer, and it shows (0 records updated).

Answer Question   |  January 21, 2011  5:52 PM
SQL Log Files, SQL Records, SQL Server, SQLCMD

Importing a “flat” field into a Lookup Table format in SQL database
    * I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated…).     * I have created a table called tblPurpose with the [...]

Answer Question   |  November 5, 2010  10:54 PM
Access, SQL, SQL Database, SQL Query, SQL Records, SQL Server Flat File Input

Making two records into one
I was not sure on how to word the title of my questions, so it is better if I simply give you my query and result: SELECT DISTINCT PJ.EMPL_NUM, (CASE WHEN PAY_TYPE = 1 THEN RATE ELSE 0 END) AS REG_RATE, (CASE WHEN PAY_TYPE = 3 THEN RATE ELSE 0 END) AS OVR_RATE FROM dbo.tblPayrollFlashJobDetail [...]

Answer Question   |  May 26, 2009  7:16 PM
CASE statement, SQL Records

How do I limit my SQL output to one record per student?
Current resuls: Student ID: Guardian 2 Joe 2 Mary 3 Goldie 4 JIm Needed results: Student ID: Guardian 2 Joe 3 Goldie 4 Jim

Answer Question   |  May 4, 2009  3:51 PM
SQL, SQL Output, SQL Query, SQL Records