Hi all I want to save the result derived by execution of query or proc into a excel file along with the column name. this can be done by right clicking on the query panel of the result set, But can this be done via query string.. Thanks for answering me.. ...more >>

I have a select statement and I would like to know which when clause(1st set of whens) was fired and the value of the then for further use in my query. I am wondering if this is possibly, and how it would be done. If i try and set a @variable at the beginning of the case statament i get an err...more >>

I am attempting to write a Check Constraint on an MSSQL2k server that will only allow a string to be INSERTED or UPDATED if it is formatted correctly. The correct format being, that the first character is uppercase [A-Z], and any trailing characters [a-z] in the word are lowercase, unless the...more >>

Hello everyone, please help. I have a stored procedure that returns results that will have varying number of column names. How can I call the stored procedure and save the column names into a new table? The problem with some of the samples online I see, is that they expect you to know the...more >>

I need to do a join between the following tables A -> B B -> C A -> D A-> E I know how to do all the joins between A and B and A and D and A and E but how I do insert the join between B and C from A inner join B on A.key = B.key inner D on A.key = D.key inner join E on A.key = E.ke...more >>

I'd like to ALTER a sproc if it exists and CREATE if it doesn't. Something similar to a table check that will drop the table if it exists but create the table if it doesn't exists. The following syntax isn't correct but gives the idea of what I'd like to do: if exists (select * from dbo.s...more >>

Hi is there a difference between an "insert" statement and an "insert into" statment insert #selected_agents(agentid, profileid) select distinct resourceid, profileid from db_cra.dbo.resource where (active = 1 or dateinactive >= @starttime) and insert into #selected_agents...more >>

Hi, I'm working on modifying a stored procedure used to provide data for a crystal report. The summarized code is as follows: CREATE TABLE #selected_agents ( agentloginid nvarchar(50), agentname nvarchar(50), agentID int, profileid int, resourcegroupid int, resourcegroupnam...more >>

hello I need some help. The following query works perfectly: ------------------------------------------------------------------ select * from tableA, tableB where tableA.num=tableB.order and tableA.num in ( select tableB.order from tableA, tableB where tableB.order=tableA....more >>

any suggestion on designing a a database that hold large amount of records(hundreds of millions of records) if i have a table says user, that has hundred of millon records. how do I architect the table that it will not affect the searching performance? should I breaks the users into category an...more >>

I am trying to retrieve the value of the autonumber field after adding and updating a record to a SQL Server 2005 database. I can't get it working, it always shows the value 'empty'. I've been through a lot of documentation which advises me to use SCOPE_IDENTITY, however since I don't deal wi...more >>

Hello, I'm trying recreate tables using the script that can be generated using enterprise manager. However the default values of columns are not generated. Can anyone advise how this can be remedied? Thanks Soc. ...more >>

Hello, I have a stored proc which will send an email (see below). I would like to use a daily scheduled job to check a table, and send emails to the email address field WHERE (the date field is 7 days earlier than the current date AND a status field=0). The status field would be changed to 1....more >>

When I ran the DETA on a sample trace of queries from our application (I'm hoping I did this correctly: Turn the profiler on the production dbase, capture a sample input set, then run that trace against our test server through the DETA), it told me to place hundreds of statistics onto the ta...more >>