Topics
Started by
Posts
Last post
I have a procedure that contains several execs of other procedures. What would be the best practice…
7 replies
Hi there, I'm wondering if there is a better way to write the following query (perhaps using joins …
4 replies
My understanding of CROSS APPLY is that it should behave like an inner join. In the example I've cr…
10 replies
Hello guys, I need some help in solving this issue In the below mentioned query i need to get the A…
2 replies
I need to create a query that can partition a data set and the do some updates to the partitions an…
4 replies
Hi, I need to pass comma separated values in my procedure but i have problem. Example: Declare @st…
10 replies
Hi all, Little problem I am facing. How to return a 0 value if there is no result, or the result it…
4 replies
Hi all, trying to learn a tsql dev stuff so decided to look at changing our ip document from a wor…
8 replies
Hello I have a select column with the format 'Physician->Scotland->Scotland North->NOS431 …
9 replies
I have a problem with modulo operator. I have records that meet the criteria x%2=0 but i dont get a…
36 replies
SELECT E.EmployeeID, …
2 replies
Greetz! I'm trying to use a uniqueidentifier in a where clause and I've been unable to get past thi…
3 replies
I have a sproc that counts the number of records where certain columns from matching records in 2 t…
4 replies
I need to find intersecting records from a table in the form of count., How many User Id count wher…
11 replies
Hi, I would like to create a trigger for insert and update whenever change the table or a record is…
3 replies
Viewing 15 topics - 6,946 through 6,960 (of 10,635 total)
You must be logged in to create new topics.