Topics
Started by
Posts
Last post
I am curious to know, if there is any way to remove zeroes from numeric column without convert…
14 replies
Hi All, I would like to calculate the work week starting from the Sunday of the week in which …
10 replies
In the below given schema and data, we need to find the time waited for each vehicle and number of …
4 replies
In a SQL Agent job step, if I specify the server name, all works well. But, if I change to "locahos…
1 replies
I have these two tables CREATE TABLE MyTable ( WillField VARCHAR(10), Surname VARCHAR(30), …
10 replies
Hi All I need your help.I am working in a project to create a datawarhouse in azure sql serverI'am …
6 replies
Hi , I have a query which is taking a lot of time because of a Distinct column.Ca any one suggest …
3 replies
Hi All, Could you please help me in get the script for below scenario: Table Creation and Insertion…
12 replies
I have CREATE TABLE myTable( UpdateDate VARCHAR(30))INSERT myTableVALUE…
2 replies
Hi Guys, Need big help. Working on a project where I can use Merge Statement. We are processing a l…
3 replies
I have a database which is supplied by a vendor, they say we cannot have db foreign keys as the fro…
2 replies
I have a need to store hierarchy data where the nodes are punctuated with fixed data. As an example…
6 replies
I need the the start date if the week given a date and which day starts a week. Here is an example:…
7 replies
I'm working with a 3rd party database where rows in each table are given a surrogate key (integer) …
16 replies
In the example below, columns 2 - 4 are dependent on the EmpId column. Columns 6 and 7 a…
5 replies
Viewing 15 topics - 991 through 1,005 (of 1,518 total)
You must be logged in to create new topics.