Problem is that disk space *is* an issue. We're currently looking at 24gb of free space, on a drive that has 150gb of space. There are plans to get more...

found this, might be useful for you:

WHERE ((DATEPART(dw, [Your_Date]) + @@DATEFIRST) % 7) NOT IN (0, 1)

that excludes weekends from your query. the @@DATEFIRST part is necessary to adjust for...

there's plenty of beginner-level tutorials in to database programming. The site that I find does the job best is W3Schools. See here for their tutorial on SQL: http://www.w3schools.com/sql/default.asp

@jeff,

I understand the relucatance to use loops in order to do set-based processing, but lets say you had a table which had a million records in it, and which was...

personally, the rules that i stick with are, for table names, try to keep them as descriptive as possible, even if it makes them a bit long. for the names...

For starters, you should definitely re-write that UPDATE statement.

People will immediately harp on the fact that you are using the old-style joins, by using a comma to separate the tables....

though I should note, if your table is *only* going to contain two columns, such as perhaps if it is a link table between two tables that have a many-to-many...

primary keys are the physical structuring of the table. any query against the table will always use the primary key, unless there is a covering index which can supply the...

See my edited post - the changed version of the query should work for returning only records which have a single rctype.

Are you saying if there is a claim number which has two rcclaim records, but which has both rctypes the same, the record should be returned? IF so, this should...

bopeavy that is exactly the query he wrote 😛 he wants to avoid having two joins on the table.

Would this work?

SELECT aClaimNo, adt

FROM Credit

JOIN RCclaim ON aclaimno = rcclaimno

GROUP BY aClaimNo, adt

HAVING COUNT(*) = 1

I'm betting that if you looked into the integration services task, you would find that the OLE DB Source Input Data is importing the data in one format, and then...

You probably meant to have the question number change for each line along with the answer number, in which case this would produce your output. However, you are dealing with...

Try this. Though you really need to give more data to make this a more complete solution:

CREATE TABLE #Items

(

ID INT IDENTITY PRIMARY KEY,

ItemID VARCHAR(5),

Price INT

)

CREATE TABLE #Mapping

(

ID INT IDENTITY PRIMARY...