Topics
Started by
Posts
Last post
Hi all. Below I am creating 3 tables. Order_hdr (OH), Order_dtl (OD) and Product_Stat (PS). I had…
8 replies
I need to pull previous day data from midnight to midnight . Meaning 7/25 12:00 am to 7/25 11:59pm.…
4 replies
I have a table keyed by an id and entry date that has a lot of data nulled out before the last row.…
6 replies
Hi, I have a query as follows. I have also listed the indexes on them. I am unable to understand th…
17 replies
Hello, I am a bit lost in regards of pivoting data. Is it possible to pivot a data-set without an a…
5 replies
Hello All, We have a table who have lots of data in it so we created table partition with date colu…
5 replies
I have first query which gives me list of all jobs with column duration ( but that duration is not …
2 replies
I have few quick questions 1) If table variable is storing in tempdb why can't I use them like tem…
12 replies
Dear Experts, I want to hide/lock my some important store procedure code without encryption. no one…
6 replies
Hi, I need to remove the extra comma before the NameComma field if for the same ID we have a NULL o…
9 replies
Hi In my table component information ID is stored as comma separated whenever multiple items are s…
9 replies
This is a time interval combing question of time intervals. I have two tables a Shift and Shift Ac…
5 replies
So, I've source as view on one database. It loads data to a table in different database. I need to …
1 replies
Hi, I need to get -5 hours from my time . Example 12:00:01 should be 07:00:01 Thanks, PSB
5 replies
Hello All Need a tsql query in sql server 2012 for the below. We have a table with parent_id and ch…
8 replies
Viewing 15 topics - 1,861 through 1,875 (of 4,984 total)
You must be logged in to create new topics.