Topics
Started by
Posts
Last post
Hi! i have two tables that are category and products. when i select a catageroy(on my asp.net proje…
8 replies
select ENTRY_DATE from CIRC.SUBS_TAG where ENTRY_DATE <> '10/27/2010' I get "ORA-01843: not a…
6 replies
Hi , with the below table with sample data , I have 10k records like belowise isbn GROUP FORMAT 9…
3 replies
I'm creating an "audit mechanism". Where I can track changes to data that interests me. I created a…
8 replies
I had a developer show me some tsql which is puzzling. He does a cast with inline and it works fin…
6 replies
Right now i have a field like this, which is a combination of path and file name: /folder/folder1/f…
8 replies
I am using SS2K8 SSMS, Fld1Fld2Fld3 A1/15/201015 A2/16/2010 A4/17/201035 A5/15/201065 A6/…
2 replies
I came across a problem. Declare @tab1 table (ID int, Name varchar(10)) insert into @tab1 values (1…
9 replies
I am using a Stored procedure consist of some Update queries. These update query taking more then e…
6 replies
Hi how do you set a variable in a select statement like: declare @FirstName varchar(50) declare @La…
2 replies
I have the tablename in a @variable. I build the SET IDENTITY_INSERT and execute it. There's no err…
4 replies
I can easily find the current execution status of my job, but having difficulty determing which ste…
3 replies
I have Transaction,which includes a lots of Updates and Inserts.If I use RowLock hint with my Updat…
2 replies
i want to select only few fileds in a pramater store proc know i can do it white dinamic sql creat…
4 replies
Hi, Can you please help me to convert the below rows into columns. Input table : dealerid amgid …
2 replies
Viewing 15 topics - 8,956 through 8,970 (of 10,635 total)
You must be logged in to create new topics.