Topics
Started by
Posts
Last post
Hi , I would like to join two tables A and B. Table A has a column Drug and table B has column drug…
3 replies
please help me below is the source table new proj id old proj id 1084d 1084/ 1084e 1084a 1084f 108…
5 replies
One of our developers feels that invoking RAISERROR in a stored proc where XACT_ABORT is on should …
2 replies
HI, I need help writing a query. Where in a table ABC.... there is code column codes (ab, bc, cd, d…
3 replies
Let's say I have two tables - a Persons table and an Addresses table. One person can have zero to m…
7 replies
This is a sample of a stored procedure I have: (select users.fullname + ', ' as [text()] from users…
4 replies
Hello ! Guys Here is a SP that I have constructed . USE IRISDW_B4_FEEDRUN IF OBJECT_ID('Pr…
1 replies
Hi, I got a database of 20gb . Now i want to perform ETL process on that database so as to copy tha…
4 replies
Hello ! Guys here I have a SP which is performing well, but I need to modify something in it. I …
3 replies
Hi everyone, Today I came across with a kinda tricky query. I was asked to retrieve codes that are …
12 replies
I have the @query_result_width = 32761. It appears in the email as it appears below. Is there a way…
1 replies
Hi, For example, I have a table like this: IDvalue 15 25 37 47 57 67 79 89 95 1…
15 replies
Hi ! Folks Please help me in performing a change in the output of a particular stored procedur…
4 replies
Hi, I was trying to add a referential integrity to the new table that I am going to create. I am ge…
1 replies
Hi everyone, I've just joined an organization that has not previously had a DBA, but has around 40 …
1 replies
Viewing 15 topics - 9,766 through 9,780 (of 10,647 total)
You must be logged in to create new topics.