Topics
Started by
Posts
Last post
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
Hello I am trying to query when a serial number is opened in a report within 60 days of the last ti…
13 replies
hey guys, i have heard a lot of good things about this forum and i am new to it. I have a question …
10 replies
Hi, I need to pass a parameter into a stored procedure which values are dynamic always. Executing a…
19 replies
Viewing 15 topics - 9,316 through 9,330 (of 10,647 total)
You must be logged in to create new topics.