Topics
Started by
Posts
Last post
I am trying to grant a teacher the ability to view database audits for his students, who each has a…
6 replies
Hi Guys, I have one new challenge to generate UserName from the table, below i provide some sample …
32 replies
Hi Guys, I have one situation where i need to update username, see the sql code first, CREATE TAB…
2 replies
Hi, I have used 'XML path' to convert values of one column to comma separate string, based on the o…
3 replies
This is the temp table I haveID empnum email …
7 replies
I have written the query below which returns the data in format shown in the screenshot shown below…
6 replies
Hello, I'm doing this: ...unionselect 'EVY', 'Everyone', ...from ...where&nbs…
13 replies
showplan denied when sproc deployed using "WITH EXECUTE AS OWNER" Msg 262, Level 14, State 4, Proce…
5 replies
Hi, Below the sample data to play with, Declare @Test table(Id int,Name varchar(50), Value int);&n…
2 replies
I am trying to get a list of rows for each customer based on quarters of a year. If I ask for…
2 replies
Hi first post I think this is the right forum. A bit of a novice but working on it. I am working wi…
12 replies
How can i compare and find the values from two tables having column below like this. Table AColumn …
6 replies
Hello, I have a tracking table (Bankruptcy_Tracking) that tracks when steps are completed in a proc…
4 replies
I cant run the query because of subquery returned more than 1 value due to coalesce. But, we need c…
2 replies
Hi,Is there a better way of doing this? I'm joining back to the same table 4 times and counting fro…
5 replies
Viewing 15 topics - 211 through 225 (of 10,647 total)
You must be logged in to create new topics.