Topics
Started by
Posts
Last post
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
Looking for alternatives in SQ server for the below 3 options (currently these been performed…
1 replies
hii am trying to create dynamic query for below codeselect * from ac_mast where opendat…
12 replies
I wrote a query where I want to filter between 2 values. First I wrote a simple query:SELECT …
2 replies
Viewing 15 topics - 1,021 through 1,035 (of 1,544 total)
You must be logged in to create new topics.