I have a rather long, complex view that should only be called from inside a stored procedure (one r…
Andrew in WV
9 years, 3 months ago
We are doing an ETL from one database into another database.
Our source data table has a primar…
Here is the situation:
On the one side we have a SQL DB with staff (active & term…
9 years, 4 months ago
I need to design a DTS package where the destination sql server table is dynamic based on the in…
9 years, 5 months ago
I have a very unique requirement and I need some advice on the best strategy to tackle …
9 years, 6 months ago
I have created my own DB which included a table named "Tables_Information". In this t…
By: Greg Charles
Is there a way to get a listing of tables on a particular file group from the INFORMATION_SC…
9 years, 7 months ago
I want to design a database in which editing an information requires an approval. and only w…
9 years, 8 months ago
I keep hitting this scenario, and would like to know what people think is the best approach.
9 years, 9 months ago
By: Brian McGee-355525
Lets Create a table
Create Table test(Name varchar(50), SalaryAmount money)
insert into test(Name, …
10 years ago
We use the standard log shipping in SQL2K to replicate over a wide area network.
10 years, 1 month ago
Not again you sigh... 🙂
Well, its on for young and old and im in the thick of it yet again. Tab…
By: Roy Ernest
I wanted to create a procedure which automatically sends email to people on their birthdays.
10 years, 2 months ago
By: Steve Jones - SSC Editor
Hi guys , we have created a simple asp.net/sqlserver 2000 based Buisneess Process Management tool i…
10 years, 3 months ago
By: Florian Reischl
I have heard some criticism of doing concatenation (building delimited strings ) in T-SQL. Two r…
The Dixie Flatline
10 years, 4 months ago
Viewing 15 topics - 16 through 30 (of 372 total)
You must be logged in to create new topics.