Topics
Started by
Posts
Last post
Goodmorning, I am having a problem with a query I wrote. When I run it, the error: Subquery returne…
2 replies
Hi All, I need your advise, please. I have to extract a very simple data from a SQL: one main table…
14 replies
Please help me in getting the results as shown in the screen shot
10 replies
Hi All, I am trying to pivot in SQL. I want dates as the two pivoted columns. The code runs fine wh…
4 replies
I have Sort order I want to do where if a parameter is 1 then it is sorted by one column and if 2 a…
2 replies
Hi all- I have the following EAV table based on exam data which we are receiving: CREATE TABLE [dbo…
5 replies
Hi There, Ive been from pillar to post on this topic now and I'm still no nearer to achieving my go…
6 replies
To find the erroneous data in a column level, no special characters are allowed as well as no numbe…
4 replies
Hi All, I have an issue regarding the parameters in one of my stored procedures. DECLARE @start_da…
4 replies
I would like to test a delete statement, but I don't want to commit it yet. I know I can use a sele…
8 replies
i need to switch the partition, before switching how can i check whether data exists in partition o…
2 replies
How can I change optimize query below to reduce the time it takes to run it against the table descr…
9 replies
Hi, Using DB Mail, I am attempting to audit a reference table. The query looks through new data and…
6 replies
Hi, I capture IO about particular Query by using this script --batch execution statistics SELECT s…
1 replies
I’ve been asked if there is a method that would allow a search string similar to the line below com…
8 replies
Viewing 15 topics - 7,906 through 7,920 (of 10,635 total)
You must be logged in to create new topics.