Topics
Started by
Posts
Last post
I am trying to pull date format yyyy-mm-dd hh.mm.ss from '2016-07-05 02:38:52.1900000 -04:00' my sq…
3 replies
I ran into the following anomaly when studying the effect double hyphens have on the behavior of nu…
5 replies
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
Viewing 15 topics - 1,861 through 1,875 (of 4,986 total)
You must be logged in to create new topics.