Topics
Started by
Posts
Last post
Hello all, My end goal is to write a procedure which can do both of the following: Return all exten…
6 replies
By: tony28
In my EDW Environment we have 512 GB RAM on SQL Server 2012 and in that we gave 471 GB as Max memor…
2 replies
By: tony28
HI friends, Is there any way to rewrite this query from performance point of view - DECLARE @var1 …
2 replies
I am a newbie in sql. recently i came across a set of questions specific to query a denormalised ta…
24 replies
Hello, The following query pulls back a number of dates. select rcp.CalendarPeriodId ,rc.C…
10 replies
I found some great Audit trigger code on the interwebs and have been using it successfully for some…
6 replies
Hi All, I've inherited this stored proc and I'm trying to improve the performance of it. I really h…
7 replies
Hi Following is the result generated from query which gives rank I need to set Code = xxxx for ID =…
4 replies
I've inherited an ETL project in SSIS which gets the latest records from our legacy database and im…
5 replies
Hi All, Need assistance with a select query. I need to write a statement to provide to a third part…
7 replies
A Friday afternoon noodle scratcher. So I have the following query: select Cast(Cast(Year(post.C…
8 replies
Hi All I have two tables t1 & t2 which contains the same records. t1 is for bank1 & t2 is…
16 replies
hey gents - I have a query that shows me distinct codes from a column called NT_ID as well as their…
9 replies
Hi, Something else I am new to and struggling with is writing Stored Procedures. I have the follo…
10 replies
Hi all, I have 3 tables that contains some texts. CREATE TABLE Article ( Id INT IDENTITY…
12 replies
Viewing 15 topics - 2,296 through 2,310 (of 4,984 total)
You must be logged in to create new topics.