Topics
Started by
Posts
Last post
I'm not exactly sure how best to tackle this. Below is the setup. I removed columns that are inco…
4 replies
Just after some advice if possible. I had a Stored Procedure which had a join to a Scalar Valued Fu…
5 replies
I have inherited this query that is comparing data from one table to another. It is using a combin…
10 replies
Hi, I have a query which takes more than 2 min whenver it runs. Is there any other way to wrtie thi…
5 replies
Hello, I am currently working with SQL Server 2008 R2 SP1 I am trying to find out if anyone knows…
4 replies
Hi I have a field in a table that represents the status time spent on activity per employee. The f…
2 replies
I've encountered a very weird error when using an OVER clause, which i cannot explain. I'd be inter…
4 replies
I have a report that calls procedure. Procedure is simple select from VIEW: ... FROM vwNzEmpNonPrj…
6 replies
Hi Folks, Can someone help with the following on SQL Server 2008... I have a table Customer and an …
9 replies
Hi, I have the sql sample code and the below image has the ouput needed.. thanks in advance... I`m …
12 replies
I want to create an update or replace statement which replaces Event_Code column with repeating val…
3 replies
Hi all - I am preparing create tables with test data, but I thought this might be so simple and g…
11 replies
I'm completely lost on how to do this. I basically want to do a CASE statement that looks at multi…
6 replies
Happy Friday Everyone I am playing around with some code, and trying to learn some things. If you e…
7 replies
Can you please explain how PIVOT is used in this query? i.e. logic behind the working of PIVOT in t…
6 replies
Viewing 15 topics - 3,001 through 3,015 (of 10,647 total)
You must be logged in to create new topics.