the lead programmer who designed and built the system here put one database per customer with one database for all customers - for those system tables and user functions that...

I can test in Visual Studio (I have SQL Server Express on my machine)

left click and Step Into User Function or something like that

this is all well and good but if company B won't bring you on as a contractor being represented by company X because you worked at company B before, being...

I lost a job because of a non-compete clause. The only good to come out of it was to show that my would-be employer had principles. I think...

worked like a charm

took a bit of futzing to get Element with Attribute nodes in VB.NET

but it turned out to be very simple code

thanks!

actually, all I need to put into XML are the keys of the records to be changed

the price will be the same for all so it can be a separate...

If there is no pressing need to generate the numbers in SQL consider generating them in code

I found that the rand() function would repeat numbers, defeating the purpose of random...

" I've rarely used the debugger, "

you're a better developer than I (goes without saying)

I don't always need to debug every new stored procedure I write but when I do...

I worked last winter at a shop with a flavor of SQL Server 2005 with debugging capabilities - within SQL Server itself I could right-click on any stored procedure and...

to clarify passing a parameter from a stored procedure into a function, especially if both parameters have the same name, DECLARE a variable of the same type and set it...

you could throw in a few judiciously placed PRINT statements, as already suggested

don't you have a debugger for your stored procedures? if not in SQL Server itself then in...

Working from home is not always a good thing. A man who used to live in the apartment above me worked at a Internet media company (now defunct) and...

I accomplished this task by declaring synonyms

there is a "master" application database which has a table containing all the other databases

the cursor creates, using dynamic SQL, synonyms for every table...

When I started at one job the first thing my new boss did was google me - and found my interests, which weren't "controversial" here in Connecticut but might be...

Jezemine has a good point - put SQL in code and there is one more place that hast to be scanned whenever tables changes are made

IMHO I think it is...