Topics
Started by
Posts
Last post
Hi. i have two database on sql server. Can i write a view that uses two database. So, it takes a ta…
2 replies
Hi, I have a query running in 2008 which takes 100 seconds to run. I checked the execution plan and…
12 replies
I have to pass a list of groups to a function which return those groups and their sub-groups till n…
13 replies
Hi, I have a table where we will store the details of when a call made to customer. it has a column…
5 replies
Hi everybody, I need to disable lock escalation for a SELECT ... FROM table_name that is part of a …
5 replies
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
Viewing 15 topics - 6,796 through 6,810 (of 10,635 total)
You must be logged in to create new topics.