Topics
Started by
Posts
Last post
When i run this code below in Query Anayzer SQL Server 2000 I get error Incorrect syntax near '('…
11 replies
I need to do a comparisson of retailer chain and store records in two different databases on differ…
3 replies
Scenario: ClosingWeek (table name) Date (column) 2008-04-21 2008-04-28 2008-04-01 2008-04-07 2008-0…
2 replies
I have a very simple table: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[C…
4 replies
I am using select statement to print the output of the table to the email messages. I want to avoid…
15 replies
recently i had a need to use GETDATE() within a function. The result? Server: Msg 443, Level …
23 replies
I have 3 tables 1,2 and 3. They all contain identical columns. How can i join these tables in order…
5 replies
I am totally missing something here and feel ridiculous but I need help. I have a DTS package that …
1 replies
How can we print system messages using queries. Say Error 547 from sysmessage table. The sysmessa…
3 replies
I am trying to migrate DTS packages which contain custom tasks from one server to another. I tried …
4 replies
Hi Guys Just a small problem, but not having much luck. I need a stored proceedure which will searc…
8 replies
Hello, Say I have a table with content as below: ID Rule Pass Fail 1 rule1 0.3 0.7 2 rule2 0.3 0…
4 replies
I have added a linked server to Oracle (Think version is 8i) using EXEC sp_addlinkedserver &…
3 replies
When the end user do not select the value(which default Value is Select One) and I want to insert i…
5 replies
Hi, I'm new to sql and was wondering if it is possible to calculate overtime hours based on daily t…
10 replies
Viewing 15 topics - 3,616 through 3,630 (of 17,082 total)
You must be logged in to create new topics.