Topics
Started by
Posts
Last post
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
We're having a bit of a performance issue with one of our tables, which seems to be behaving in a s…
10 replies
Suppose we have the following table. We have everything for the address packed into one cell.…
6 replies
Hi Guys, I need advice. I have almost 30 Update statements with different logic in one stored proc…
8 replies
Hi, I am aware that Redgate has a free ebook that explains …
6 replies
Viewing 15 topics - 1,021 through 1,035 (of 1,539 total)
You must be logged in to create new topics.