Topics
Started by
Posts
Last post
In a sql server 2008 r2 database, I am using a table called 'appclose' as a reference table. This t…
1 replies
I have been creating tables left and right. The past two weeks I created hundreds. About 30 minutes…
2 replies
We have a table data from other source. One of the columns Model is varchar(5), most of values are …
7 replies
hi i want next day function for example. if i enter 12/31/2008 ,it should give me 01/01/2009
6 replies
CREATE TABLE [dbo].[Abc]( [sid] [int] NULL, [sname] [varchar](20) NULL ) ON [PRIMARY] GO SET ANSI…
2 replies
my stored procedure. its used to insert the data and increment idcount by one till the end of the y…
4 replies
Hey all, I have this query SELECTa.Report_Menu_Code , a.Menu_Name, b.Sub_Menu_Code, b1.…
17 replies
I am pivoting against a dataset and that works, but I want to add GROUP BY ROLLUP so that I can hav…
7 replies
Trying to do what I thought would be a simple LIKE wildcard query but I can't get the syntax correc…
13 replies
hi We need to combine two DML Statement into one statment update B Set B.phone_disp_new = ISNULL(A…
2 replies
Hi All, I have a table of stock details for NSE holiding Daily data. Here is the structure of the t…
18 replies
Hi All, Now in the SP shown below, I want to control the where clause from outside (Application). …
7 replies
Does anyone have a simple Stored Procedure that uses a MERGE Statement uses BEGIN TRY/CATCH Error h…
34 replies
I have a Table T1 with columns Col1, Col2, Col3, Col4, Col5 having primary key on columns Col1, Col…
3 replies
Hello all, having a table like this one: ID - DateRef - GroupID 17 2012-06-20 10:00:00.000 463 21…
10 replies
Viewing 15 topics - 5,461 through 5,475 (of 10,644 total)
You must be logged in to create new topics.