Topics
Started by
Posts
Last post
I have a staging database and also a production database. I also have two ssis package to load data…
9 replies
My predecessor came up with the following rule: When doing table joins, always use the INNER JOIN /…
18 replies
I have a program that dumps data into a table nightly. After the program is done. I end up with a 8…
10 replies
Hi, I have two tables: Table 1 Account Amount 1 1000 2 500 3 1000…
1 replies
Hi, i'm not able to index a view as it is built on several tables from different servers. does the…
12 replies
Hello All, I have a code and I am trying to use Merge statement. MERGE DBO.DASHBOARD as target usi…
4 replies
can someone plese help? I am attempting to determine when a backup is complete using sp_who2. If b…
8 replies
Hi Friends, can some one please help me with script which data file auto growth is not set to 5gb a…
1 replies
Hi Sirs, I have a query as below and takes almost a minute to execute. But if i replace IN clause w…
3 replies
so I have a field of 100 patients, and their daily dosages..20mg, 40mg, 25mg ect..... I'd like to h…
1 replies
Hello gentleman, Here is the problem I am facing into SSRS. I have a column "description" which has…
1 replies
I have a table named as Modules CREATE TABLE #Modules ( [ModuleId] [int] , [ModuleName] [varchar…
10 replies
Hello all, Is there any other way to write this code with out using union's? As there are more then…
2 replies
Hi, I have two stored procedures: CREATE PROCEDURE OuterSP BEGIN BEGIN TRY BEGIN TRANSACTION; …
3 replies
Dear All; I am doubt for calling the SP with in the select Query This is my sample procedure EXEC […
6 replies
Viewing 15 topics - 6,826 through 6,840 (of 10,635 total)
You must be logged in to create new topics.