Topics
Started by
Posts
Last post
Dear Experts, I want to create 1 Million row on the fly without using Cursor or While loop. How ? I…
6 replies
I found this script in the SCRIPT section and it's a nifty thing. set ANSI_NULLS ON set QUOTED_IDE…
3 replies
Hi all, I have an Audit table that contains customer records. These customer records are being chan…
9 replies
I have a stored procedure I want to execute and have the results in a table so I can process it. I'…
2 replies
Dear All, I have to 2 DataBase DBMain and DBAudit, All the Tables in the DBMain will be in the DBAu…
2 replies
I have an audit table that is populated when a user makes a change in the database, showing a Befor…
1 replies
I've got a very strange problem with an updatable cursor not advancing. The table has a non-cluster…
8 replies
I have one senario. Query: Update Emp set CounterPart = count(*) from Emp1 A,Dept B where A.Eno = '…
4 replies
Hello, i´ve a rather long sql - script which moves data from one database to an other. This is done…
8 replies
Using SQL2000 I need to use an BinTypeID in a WHERE clause stored in a string field that contains X…
1 replies
Hey all. I have a question about my script below. It dies and ends if 1.) I do not have a login o…
1 replies
Hi, I have a table with around 60 columns. 20 of them have a name that begin with "aa_". I want to…
11 replies
In the following union query how do I order by ProviderNameLF ? SELECT TOP 100 PERCENT p.PartyID …
2 replies
Hi at all, i need to export a table where there is a column type char(10). I have to convert it in …
3 replies
Dear All, I want to copy a table and its data from PROD environment to DEV environment. Note: I don…
5 replies
Viewing 15 topics - 2,971 through 2,985 (of 17,082 total)
You must be logged in to create new topics.