Topics
Started by
Posts
Last post
Hello, I have a table and data like below CREATE TABLE [dbo].[p2p]( [p2pid] [int] NULL, [p2psourc…
21 replies
Hi We have a scenario, where busniess users are presented with a screen with 20+ fields. They can c…
16 replies
I am stuck on a very repetitive query now, I wonder if anyone can help me on figuring out a smarter…
20 replies
There is stored procedure which show no error but keeps on executing with stop.I had placed some se…
3 replies
I'm trying to make a script where I can add leading zeros to numbers less than 7. I have it almost …
8 replies
Hello, I have a table A like below Acctnum StartDate AAA 07312016 BBB 0630…
8 replies
hi, i use loops sparigly , but when ever i use them , i see following pionts like 1) i am readi…
6 replies
hi, 1) should i remove loop with follwiong query. 2) and is there any other way to do it, with out …
11 replies
Hi! I am not sure if this question has to go here, I wait don't mistake! I was doing tests for the …
2 replies
Hi Gurus, I have list of quarters in my db table as below: PERIOD_QTR 2014 QUARTER 1 2014 QUARTER 2…
11 replies
HI, Im checking default constraint for 2 columns.I want to check whether the below mention query is…
2 replies
I'm working on a project with a co-worker and I was working on creating a database for some integra…
11 replies
In a sql server 2012 database, I have a called that is declared as varchar(max) where the column is…
4 replies
I'd like to get some help on merging consecutive dates if FLAG is same. -- INPUT IDEfftDTTermDT…
2 replies
By: Coconut
I have the following SQL generated by a third party application that is using a wrong index and cre…
13 replies
Viewing 15 topics - 1,546 through 1,560 (of 4,984 total)
You must be logged in to create new topics.