Topics
Started by
Posts
Last post
Looking for some suggestions on how to perform an update. Here is the task. One table has two colu…
11 replies
By any chance, can we optimize the below query..This is running for 2 hrs..As of now, i really don'…
18 replies
Good morning all I have a table that looks like this: Count Bin Date 1 2AA 25/09/2010 2 …
4 replies
hi I have a select statement in sql 2000, with the select on a linked server (oracle) table. For ex…
1 replies
Hello. Rather than write an app I thought I could quickly code up a report that had all the fields …
1 replies
When I use BULK INSERT with TRY CATCH Block, only the last error message is caught in the TRY CATCH…
1 replies
In SysServers we have the Last_Run_Date and Last_Run_Time. How do I find out if the Last_Run_Date a…
14 replies
I have a query that takes about a minute to run. Is it possible to make this query run faster? SE…
8 replies
I am inserting into temprary table using INTO statement by execute sqlstring. e.g Declare @sqlstri…
3 replies
Hello All: I have a table that lists column names that I would like to use for a new table. The ta…
5 replies
Hello I am new to writing sql queries and am not sure how to write this up. Here is what I have so…
6 replies
Hey folks, I'm trying to construct a procedure which will duplicate a block of users in one organiz…
6 replies
Hi All, i have a table with following structure CREATE TABLE [dbo].[DateFormat]( [WDate] [smalldat…
8 replies
I am using sql server 2000. Below is the scenario: I have 3 tables: select * from A1; gives: agenti…
1 replies
I have code using dynamic SQL that has dynamic SQL because of changing WHERE Clause. I want to elim…
12 replies
Viewing 15 topics - 9,301 through 9,315 (of 10,635 total)
You must be logged in to create new topics.