Topics
Started by
Posts
Last post
Hi Guys Unable to Insert Dynamic Database name into new table here is my query This is the cursor i…
10 replies
Im trying to update a table but having difficulty, if I just run the sql statment I retrieve data b…
2 replies
I would like to convert/cast GETDATE() into a string but keep the format YYYY-MM-DD. If I use a CAS…
2 replies
Hi All, I have an interesting problem where I need to find the longest period of consecutive days f…
6 replies
I have a database in which assets have been deployed to multiple users on various dates. I need to…
22 replies
Hi, Can you create a join on a row but join it in such way that it acts like a distinct. Ie. Conver…
1 replies
Hi, Before FirstName = Harbour Twain in T1 is deleted, it has to check that FirstName = Harbour Twa…
4 replies
Hi I have the following query SELECT ITEMS from FROM ORACLELINKED WHERE ITEM_NUMB…
2 replies
Hi Guys, this one has really got me stumped, I may have just been looking at it too long and missin…
7 replies
I have searched for a way to do this but can't find the answer. Maybe it is not possible? I am tr…
4 replies
I have a field that gives me the week of the year (pre defined fiscal periods) and I am trying to b…
2 replies
I have created a trigger below. The cursor is cuasing the update not to work at all. When I comme…
15 replies
Hi, I am getting the following error while doing a BULK Insert. column 1 (a).,Bulk load data conver…
3 replies
I got into a strange situation. I tried to use covering-index using the INCLUDE keyword. But, I's i…
8 replies
EDIT: Please scroll down to Post #742587; I've rephrased the scenario to remove Ambiguity. Hi , H…
10 replies
Viewing 15 topics - 1,561 through 1,575 (of 17,082 total)
You must be logged in to create new topics.