Topics
Started by
Posts
Last post
CREATE PROCEDURE usp_update @pcid int ,@ppid int ,@ptid int ,@pqty int AS BEGIN SET NOCOUNT ON; DEC…
20 replies
I have 2 columns in the database. The value in column 1 is 10000000. The value in column 2 is 987…
15 replies
I want to select a field that has a value of 0 or 1. I want to select that field but have it print…
3 replies
Hi All, I'm trying to set up a view that will allow me to re-organise and existing table for the pu…
9 replies
Just curious: is it possible to perform a UNION between two stored procedure executions (that both …
3 replies
CROSS APPLY ( SELECT col = CASE WHEN MAX(col) = MIN(col) THEN MAX(col) ELSE NULL END )
3 replies
Hi All, following is the result of my query Year_Month.........cat1_per......cat2_per........cat3_…
3 replies
I have a C# assembly that returns a string. I created an SP to call this assembly and it works. But…
2 replies
Hi, Anyone knows about this? I want to make SSRS reports based on cube(SSAS). Now further more I wa…
1 replies
I need to determine the unique combinations of group permissions assigned to users. Currently, per…
4 replies
Hello All, I have some really ugly data coming in from several files. I am using SSIS to import int…
5 replies
Hi I have 2 tables Rates and Records. RATES table country fromdate todate…
15 replies
Hi, I have this below script and need the output in excel in D:\Reports folder. Anyone can help me …
8 replies
Hi I have this query - SELECT * FROM [GATE].[dbo].[DATA_CLOB] WHERE RAW_CLOB LIKE 'AAA|E0221002|_|…
2 replies
I need help regarding the issue having on performance and size. We have a Database : (History_price…
5 replies
Viewing 15 topics - 4,951 through 4,965 (of 10,647 total)
You must be logged in to create new topics.