Topics
Started by
Posts
Last post
I have a Contact table where I enter a "Parent" (Mother or Father) with IsSubscriber = 1. I also e…
5 replies
Some new functions (eg. CONCAT) work as soon as you migrate to 2012 and leave compat mode at 100. …
5 replies
Code is below, and DDL is in the text file (sorry, it's long). I was sort of expecting the 10 minut…
4 replies
Hello Everyone I am working with some money, which is always fun. I would like the DECLARE @MyPay…
5 replies
HI all, I have a dataset where i want to select the records that matches my input values. But i onl…
9 replies
Hi, I have a data of 100 PostalCodes and parcels associated with it. Each postal code will be havin…
8 replies
Hi all , following is my SP , when I just comment the where clause i.e. o.StatusID in (Select osl.…
1 replies
Hi, I need to calculate cum amount from the following table. CREATE TABLE #TotalRevenue_Investments…
3 replies
Hi, I'm new here. Hoping you guys can help me out.. Let's say I have a table of data as per the bel…
7 replies
Hi SQL Folk, I wanted to get some feedback on how I am using a CASE statement within a WHERE clause…
5 replies
In a sql server 2012 database, I have a field called date of birth that is stored in a tha that is …
6 replies
Hi all, I have a system log with NULL gaps between a sequence of numbers...see "BEFORE" sample belo…
12 replies
Something I thought should be easy and probably is, but I've been unable to find a working solution…
3 replies
Hi! I'm quite new to SQL. I'm able to extract the info that I need, but only into a result of one r…
7 replies
Requirement- I have 200+ columns whose data needs to be replaced with some random values i.e. mask …
2 replies
Viewing 15 topics - 3,841 through 3,855 (of 4,984 total)
You must be logged in to create new topics.