Topics
Started by
Posts
Last post
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
Hello, I need a query where i can see in the output the following information. The spid xxx that is…
4 replies
Hi, We have an excel file that we want to create a temp table of. In my test environment I solved t…
1 replies
Could someone please help me with below script Create table priorityupdate ( aid int, priority in…
3 replies
Viewing 15 topics - 8,971 through 8,985 (of 10,647 total)
You must be logged in to create new topics.