316 reputation
18
bio website
location
age
visits member for 1 year, 2 months
seen Apr 1 at 13:50

Mar
31
asked Inside stored procedure, set column names of returned query according to variable
Mar
10
comment .bak file not visible in any directory
it did help! :)
Feb
24
awarded  Critic
Feb
24
comment Looping through string, adding all numbers e.g. '123' = 1+2+3, demo with working loop included
thanks @JNK, will only be 6 characters long, 1 row
Feb
24
accepted Looping through string, adding all numbers e.g. '123' = 1+2+3, demo with working loop included
Feb
24
asked Looping through string, adding all numbers e.g. '123' = 1+2+3, demo with working loop included
Feb
20
awarded  Popular Question
Jan
30
awarded  Yearling
Nov
21
accepted Joining 2 tables- in Select statement show how many fields matched directly (A1 = B1), vs matched on isnull(A1,B1) = B1
Nov
21
asked Joining 2 tables- in Select statement show how many fields matched directly (A1 = B1), vs matched on isnull(A1,B1) = B1
Nov
12
accepted Can I run a Report Server and a Mirror server from a working Log Shipping secondary instance?
Nov
12
accepted Can one assign a performance score to a stored proc to compare performance of 2 procs
Nov
12
accepted Does rowlocks on index cause keylocks? : Transaction (Process ID xy) was deadlocked, example included
Nov
12
accepted Can 2 tables lock each other if concurrent read/update do not affect same rows? pagelocks off
Nov
12
accepted Moving from SQL 2005 [SQL_Latin1_General_CP1_CI_AS] to 2008 - will I lose any features by using 'backwards compatibility'
Nov
12
accepted After 5 years of working, SQL Server 2k5 Table now locking without any changes made to DB
Nov
12
accepted Query has where (a = a) or (b = b) - the 2nd part causing index scan. Full example included
Nov
7
accepted Advice on setting up a Reporting server
Nov
7
comment Advice on setting up a Reporting server
Big thank you Mike Walsh, the answer below is fantastic and I am on at least a path now where I wasn't before. We have an existing application which calls the stored procs from the DB via web front end - so wont be using SSRS. Seems likes it going to be Log shipping 'with standby'. It looks like we could be moving to SQL 2008 in the next few weeks and that I can do the reporting after that. Will SQL 2008 allow me more options? thanks!
Nov
6
asked Advice on setting up a Reporting server