Topics
Started by
Posts
Last post
Hello Everyone Hope that everyone is well today. I am working on some database code. Imagine that..…
3 replies
I've table and rows as follow, CREATE TABLE [dbo].[tCout]( [idx] [smallint] IDENTITY(1,1) N…
4 replies
I'm trying to write a query to obtain 1st, 2nd, 3rd and 4th secondary diagnosis (dx) codes. The tab…
7 replies
This might seem like a simple question, but the answer has me stumped. What is a SQL statement that…
14 replies
I'm trying this at the end of an insert. The @CumulativePercentofTotal works when MonthlyPercentOfT…
18 replies
This is a problem that I've been bashing my head against the wall for the past few days on, so I fi…
8 replies
Greetings, I need some help figuring out how to do this in SQL Server. I have a scenario where I ha…
31 replies
I have two Databases - One live the other Archive so they are same structure. This is a help desk …
1 replies
We have to archive 5000K rows. 1. Insert from MainTable to ArchiveTable and then delete those data …
1 replies
Hi folks, I need write script that can be drop constraints from particular table. Afterwards doing …
5 replies
Hi, Is there a way to create a Trigger on 2 tables?I want to fire a trigger if tableA (or/and) Tabl…
2 replies
Hi all, I've got a little problem and I was wondering if anyone could offer me some new avenues to …
9 replies
I've been meaning to investigate if we can convert data from one system to ours. The database, whic…
4 replies
( This is inccorectly posted to SQL 2000 thread) Hi, I am trying to write a function converting any…
11 replies
I'm trying to use a case statement, and inside I need to have a BEGIN and END with multiple stateme…
6 replies
Viewing 15 topics - 4,141 through 4,155 (of 12,234 total)
You must be logged in to create new topics.