Topics
Started by
Posts
Last post
A customer had reported an issue with one of our stored procedures so I took a look and found that …
25 replies
Hi everybody, i have a problem with a scalar valued function. There are two systems who will use th…
9 replies
I have 3 tables. The script below returns 3 records. What I need to do is go through each record …
5 replies
Hi All, I wants to clear my concept about Temp Table, Table Variable & Common Table Expression…
49 replies
-- HERE IS THE PROBLEM.. I CAN NOT USE THE T-SQL (INSERT EXEC) IN A FUNCTION -- ADDITIONALLY, WEL…
52 replies
Hi currently Ive been using set @rowcount to select the top subscribers in a list Now I wish to se…
9 replies
Suppose I have a tree --' RootNode --' --------|------- --' …
7 replies
I have a table PS_JOB with the following records..... emplid effdt effseqjobcode 0…
5 replies
Hi All, I'm using stored procedure where i'm getting role Id in comma separated values and i need t…
3 replies
I feel like this should be simple, but I'm stumped... I have two tables, with a common ID column, w…
7 replies
Hi there - I can't seem to gather the steam to figure this out today. I need to find out what the…
5 replies
Hi there! I'm facing a problem. I have loads of data in a table that is converted using the HASHBYT…
15 replies
Hi All I got stuck in a place where i don't know what to do next, CREATE TABLE #Temp (Tx…
8 replies
Hi All, I have query regarding locking during transactions. In below query the locks on TABELA is h…
2 replies
Hi, What I need is a way to run different CTE based on the condition. Something like this: WITH C…
12 replies
Viewing 15 topics - 106 through 120 (of 12,234 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy