SQL Server database programming

I have a select statement joining several tables.  An aggregate report will be deployed in Reporting Services.  On the Layout tab, I have a table where I want to place the results. For example, I have the following result set from the table join ...

hi, i've spent ages puzzling over this, and read similar situations on the net but it's usually a different problem of people using 'dd mm yyyy' format instead of 'dd mmm yyyy'.  using sql 2005. i have a very straight forward stored procedure, with a datetime parameter ...

With SQL Server 2005, this is producing a syntax error- ALTER TABLE mytable ALTER COLUMN mycolumn SET DEFAULT 'something'; Yet google finds references that claim that syntax is supported. What is the correct syntax? ...

I have a tabled named bvc_Product and it has a parent-child relationship.  I need to update the LongDescription column on all the Child records with the LongDescription of the Parent record. So I tried the following: NOTE:  LongDescription is of the type nvarchar(max) ...

Just curious, I'm looking to CONCAT(AREACODE,'-',PHONE_NUM) is this possible using pl/sql. I know I can CONCAT(AREACODE,PHONE_NUM) but I need more than two columns/values concatenated. Thanks! ...

I changed port on sql2005 to 1400. From local computer I can connect to server (IP,1400) with sql login(sqldev) and everything works. If I try to connect to the same sql server from other computer, I get an error. ...

Hello I have a few queries that I wish to consolidate in to one, however I am not sure if it possible. Is it possible to execute an SP within another SP and wait for it to finish and then proceed with the next step? ...

Here's my issue ======== history table to select from has the following columns: Acct_id, Threshold, DateCreated In this table, there are multiple rows that contain the same Acct_id & threshold but all DateCreated dates are different. (its a history table as well as the reference for the last threshold) ...

I have a unique clustered index on a table in SQL Server 2000.  Its columns are Year (descending), Grove, Ticket.  The table's primary key is different than the clustered index. It was my understanding some time ago that if I created a clustered index on ...

I have this calculation in which I have to reverse a negative number. I am trying this syntax to no avail. Can someone give me an alternative or do I have to CASE out all my subtotal buckets??? Any help is greatly appreciated. ...

I have a source table and target table of the same structure. My source table is a staging table I want to read records in my source table and if the record does not exist in the target table do a insert ...