Topics
Started by
Posts
Last post
I have the following script: WITH A AS (SELECT c.owneridname as BSC,z.Tpl_TotalGWP as Total2012,a.…
6 replies
I have a question about what are the alternatives for LIKE '%%' and Full-Text Search when it comes …
10 replies
Hi, I'm editing a large stored procedure (very few comments) which has 3 methods (so far) of gettin…
29 replies
I have the following data: User Salesperson A23171320230.00 Salesperson B11782199584.00 Salespe…
8 replies
My concern is how implement the following query, thanks in advance for any help. I am reading regar…
3 replies
/* Objective: if report is for Year 2009, and 2009 is the first registration year, then return Prog…
6 replies
Hi All, I have a client that has separate HR and Payroll systems each with their own database. Ther…
10 replies
Hi, I want to combine different periods into one, I don't know how to explain it properly, so I try…
6 replies
Hi, I wanted to have generic stored procedure where in i have to execute the underlying stored proc…
6 replies
Hello, Currently in the below stored procedure, I'm using a table variable to fetch results from th…
3 replies
Hi I have a requirement where a field in SSRS report should be shown as (Days, Hours) Ie. If it is …
1 replies
How do I get it NOT to error out if login already exists? IF NOT EXISTS(SELECT principal_id FROM s…
3 replies
Hi, In SQL 2K8, Table was created successfully, table was appear in database also select command wo…
2 replies
How could I sort the result set of sp_lock by a specific count and then pass the spid of the lock i…
22 replies
Hi I was wondering if someone could help me. Quick Background I have an attribute called ‘Vendor’ …
9 replies
Viewing 15 topics - 6,811 through 6,825 (of 10,647 total)
You must be logged in to create new topics.