Programming SQL

Check Reporting Services Installation Programmitcally
Hi, Does anyone know how to check if Reporting Services is installed through code? Thanks in advance. ... 21 Jul 2008 18:14

Please Help me with query.
create table t1(parentid int not null,childid int not null,number int null) go Insert t1(parentid,childid) values(10,10) Insert t1(parentid,childid) values(10,11) Insert t1(parentid,childid) values(10,12) Insert t1(parentid,childid) values(10,13) Insert t1(parentid,childid) values(10,14) Insert t1(parentid,child... 22 Jul 2008 00:23

Need help with a dynamic sql stored procedure
Hi, This is the final part of my previous post in the morning. I have changed the stored procedure quite a bit. The idea is the generate a select statement where the database needs to be chosen dynamically based on a parameter 'site' in the procedure. The procedure looks like the following which compiles fine... 22 Jul 2008 13:43

SP performance problem
Hi, I am having trouble with the performance of one SP.This sp is taking around 45 Sec to execute and sometime timing out.. Here is the main code of SP..This SP calls function to adjust the impression value.. I tried by creating temp table and updating through temp table but that too was taking around 40 secs..... 22 Jul 2008 12:41

Need Ideas for SQL Query
I have a query that needs to return only if there are records that match the criteria. My current query is something like this: SELECT MAX(RECORD_DATE),RECORD_NAME FROM TABLE_NAME WHERE RECORD_DATE >= '7/21/2008' /*Today's Date*/ GROUP BY RECORD_NAME The problem is that there can be thousands of records. The ... 21 Jul 2008 16:10

Need Ideas for SQL Query
I have a query that needs to return only if there are records that match the criteria. My current query is something like this: SELECT MAX(RECORD_DATE),RECORD_NAME FROM TABLE_NAME WHERE RECORD_DATE >= '7/21/2008' /*Today's Date*/ GROUP BY RECORD_NAME The problem is that there can be thousands of records. The ... 21 Jul 2008 16:10

Need Ideas for SQL Query
I have a query that needs to return only if there are records that match the criteria. My current query is something like this: SELECT MAX(RECORD_DATE),RECORD_NAME FROM TABLE_NAME WHERE RECORD_DATE >= '7/21/2008' /*Today's Date*/ GROUP BY RECORD_NAME The problem is that there can be thousands of records. The ... 22 Jul 2008 02:26

Help
I have a problem. I just inherited a program that is full of holes and bugs and I need to do some patching. Just to note everyone, I did not set up this database and I did not code this program, I am stuck with it as is. That being said, I have to do some checks on a database to make sure pairs of material a... 21 Jul 2008 18:14

select count of rows per group
I need to select the count of the first 3 rows per each group (xID) up to a count of 3 rows (top 3 rows - order by column x1) where the stat column is not null. if a group contains more than 3 rows where stat is not null - ignore the extra rows - only count the first 3 rows in each group CREATE TABLE #tmp1(ro... 21 Jul 2008 17:12

Need to return more than one record from sub-query -- why doesn't this work?
Hi Everyone, I have a question, more of why MS SQL is doing this than anything I guess. I'm writing a Case statement within my Where clause to create a conditional where, and though in theory it would work, MS SQL is complaining when I don't think it should. Below is my SQL: Select * from BillingTable Wh... 21 Jul 2008 16:10