Topics
Started by
Posts
Last post
Can someone help me removing cursor from this TSQL if its possible --------------------------------…
18 replies
Hi there, I require a count on multiple columns but excluding the ones containing zeros. Heres my c…
11 replies
hi friends i have this : Execute('Select 1 as [Test],* From myTable') how can put a character inste…
2 replies
SQL 2005, SP2 I have the following temp table in this proc: create table #Table( EID int primary k…
2 replies
when an insert happens in one table and i need to trigger that same insert into another table how w…
3 replies
I need to create a booklet of some of our 84000 tables in MS Sql I would like to be able to use t-s…
5 replies
I am trying to make a hefty SP that could move data around within our system without having to make…
1 replies
I am running a stored procedure to retrieve records with a matching name. However, when there are t…
7 replies
I've got a database backup I've restored on several SQL 2005 DEV servers and am running the attache…
1 replies
Hi All, Is there a way to pass sql statment(i.e. insert, update, delete) to a stored procedure, an…
10 replies
i have two tables table 1 create table table1 ( emp_id char(4), name char(20), DOB datetime, ) and…
5 replies
I am creating a package through SSIS. when I try to import the csv file in sql table by using the D…
1 replies
I got a which users are using my db in network with the help of Sysprocesses , but I need to termin…
2 replies
I need help to write a query for an update statement. Table Structure and data follows CREATE TABLE…
7 replies
I have two databases on two different servers. For example A and B. On A server the database uses w…
1 replies
Viewing 15 topics - 7,291 through 7,305 (of 12,230 total)
You must be logged in to create new topics.