Topics
Started by
Posts
Last post
I have an application that connects to SQL 7 database which I need to upgrade to SQL 2000. One of t…
1 replies
Hi there, There is a monthly job running to cleanup a table. Basically it says: DELETE Tablename WH…
2 replies
We have a bunch of rules (30 in one table) which have to be applied to each account which meets cer…
4 replies
I have a User Defined Function (rules_Test) which takes one argument (account number) and returns a…
6 replies
I have this big if statement checking for each different type and writing an update statement for e…
4 replies
CREATE TABLE [dbo].[emp_details] ( [emp_number] [int] NOT NULL , [emp_id] [int] NOT NUL…
5 replies
I've heard that Count(*) is a bad practice... Can anyone tell me why? Thanks
11 replies
If a record returns null for a particular field I would like to insert -1 into that row. How …
2 replies
Hi All, I need your SQL guru's help: I want to generate SQL scripts for all the objects, like table…
1 replies
This is more of a security question, however based on the audiance... I am trying to com…
7 replies
My table has a column called sql_name. I need to concatenate all the values in this column and sepa…
16 replies
SELECT listofFields FROM fTable f LEFT OUTER JOIN flTable fl ON f.gen_files = fl.gen_Files INNER JO…
3 replies
Hey All, New to this SQL Server stuff and still trying to find my way. Need help on an issue …
2 replies
Hi All, Hope someone can help........... I've got a table here and I need to delete the highest pri…
3 replies
Hi, folks! I run on this problem for some days. I have the following table, wich is updated every 6…
3 replies
Viewing 15 topics - 12,631 through 12,645 (of 17,082 total)
You must be logged in to create new topics.