Programming SQL

logic help for banner exchange system needed
Hi, i'm trying to create a banner exchange system on a 1:1 basis but stuck on weight calculation logic. with weight, i mean a logic that while deciding which site will be showed more will allow sites with less credit too. basic approach would be showing banners of sites with more credit first ; but this migh... 16 Jul 2008 10:56

Want some information from you
I want to know about, What is sqlserver? What is the benefits of sqlserver? mailto:6eS64VhxZW(a)repairondemand.com ... 16 Jul 2008 13:01

Strange fast and slow execution times
Running a particula stored procedure against a SQL2000 database within a SSMS2005 query window using identical parameter values it will sometimes run in 17 seconds and at other times runs in 47 seconds. What should I look into for the cause. What I notice is that if I have not run it in some time - for exampl... 16 Jul 2008 10:56

How do I Return Result of Case as Decimal
How do I return the following as a Decimal 10.2 Sum(Balance) asBal, Case WHEN Sum(Balance) = 0 and Sum(PER) = 0 THEN 0 ELSE Sum(Balance) / Sum(PER) End as [Average] TIA Sam ... 16 Jul 2008 01:42

build forecast
I have a process that builds records to be loaded to my forecast table and the records looks like this. MM YY Customer Type fctlbs 07 2008 abc cu 100 08 2008 abc cu 200 08 2008 def cu 200 08 2008 def cu 200 08 2008 def cu 200 08 ... 17 Jul 2008 10:38

SELECTing a range from the results
I would like to create a SELECT statement that returns a certain range of the results that a WHERE clause returns. For example, if the WHERE clause would return 75 records, I want a way to have the SELECT statement return the second 10 records, or the third 10 records, etc. I know how to use the TOP(x) clause, ... 16 Jul 2008 05:48

on allowing triggers to fire others
Let's say I want to allow triggers to fire others: Under server properties > Advanced > Allow Triggers to Fire Others = True Then I have 2 tables (table_1 and table_2) where each will have an update trigger that updates something in the other table: CREATE trigger_table_1_update ON table_1 AFTER UPDATE AS BEG... 20 Jul 2008 18:38

Query Results Using Database Mail
Is there an easy way to email the results of a query using sp_send_dbmail? I can always use a cursor and build a string for the email body, but I was hoping there would be a better way. ... 15 Jul 2008 17:30

URGENT - How to get the query request history
Hi, We are trying to trouble shoot a problem and we are not sure what is the queries that the application sending to my sql server. is there a way to audit the queries executed by SQL Server? Thanks ... 15 Jul 2008 16:28

Finding Unique Indexes
Anyone have a query to find all the unique indexes in a given database? Thanks, Mark ... 15 Jul 2008 21:37