Programming SQL

delivery extension
Hi Rick, Do you allready have a solution for this one, I'm facing the same problem. Cant see my delivery extension in the combobox neither. Regards, Valentino Rijhen Rico wrote: Re: Help! Having trouble Imlementing Report Services printer delivery extension sample 30-Jul-07 "Rico" <me(a)you.com> w... 10 Mar 2010 08:36

test
test Rico wrote: Re: Help! Having trouble Imlementing Report Services printer delivery extension sample 30-Jul-07 "Rico" <me(a)you.com> wrote in message news:RDnri.67292$tB5.18008(a)edtnps90... Alright, as it turns out, I added this right beneath Report_Server_Strong_Name Code group and it seems to keep the... 10 Mar 2010 08:36

CTE parameters
When do you need to use a column list with a CTE. This is apparently optional. I just used one where I didn't use the list but I am not sure why when I would have to. Thanks, Tom ... 10 Mar 2010 14:14

convert string to datetime
Hi all, I used this to append to a some backups. DECLARE @DATE VARCHAR(20) = CONVERT(VARCHAR(10),CURRENT_TIMESTAMP,112) + '-' + RIGHT('00' + CAST(DATEPART(HOUR,CURRENT_TIMESTAMP) AS VARCHAR(10)),2) + RIGHT('00' + CAST(DATEPART(MINUTE,CURRENT_TIMESTAMP)AS VARCHAR(10)),2) + RIGHT('00' + CAST(DATEPART... 10 Mar 2010 11:58

How to update the Year in a date field?
Hi All, ----------------------------SQL SERVER 2008 Database----- The AP clerks forgot to change the year from 2009 to 2010, so they did lots of data entry with invoice dates instead of 2010, they added 2009 and the date field looks like this "2009-01-16 00:00:00.000", is there a way to replace 2009 with 2010. ... 10 Mar 2010 03:05

order by case value
If I have the following: SELECT UserID as RID ,EnvironmentID as EnvID ,@authorType as RType ,'A' as Type ,'Author' as FullType ,Case When (isnull(FirstName, '') <> '' AND isnull(LastName, '') <> '') then LastName + ', ' + FirstName When (isnull(FirstName, '') <> '' AND isnull(LastName, '') = '... 9 Mar 2010 13:32

Full outer join on 3 tables. How to?
Hi, I have 3 tables: 1) table a: id int colA int 2) table b: id int colB int 3) table c: id int colC int If I'm given an id (e.g. @id = 2), how do I query the three tables for rows that match @id? I need a full outer join. For example, if table c is the only table containing a row matching @id t... 9 Mar 2010 12:22

Option(RECOMPILE)
I have a UDF say Which is caluculating salary of an employee by using Cusror. Now i m using that UDF in a View in which i m passing it Id for a value in view. That's working fine if no of records are say around 1000 but if No are Increasing then View is working very slow Because foreach row in view that function ... 9 Mar 2010 11:13

Query Decimal Date field for Yesterday's Records
I have a table in which the records contain a Date (DDate) that is stored as a Decimal value (IE. 30710). I need to SELECT from that table only the records WHERE DDate is equal to yesterday (Current Date - 1) and I am having a heck of a time figuring out how to do this. Any help would be appreciated! Thanks! ... 9 Mar 2010 15:50

SQL2000: Permissions Stored Procedures
I have some stored procedures, which I've granted execute permissions to a user for. When the user hits the stored procedures from an outside program, it errors out stating that the permissions are required for the underlying tables. Both the tables & the stored procedure are owned by dbo. I only want to gra... 9 Mar 2010 02:24