Topics
Started by
Posts
Last post
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
I know for a integer column(say ID) sql server truncates any leading 0's but i have a particular sc…
10 replies
I'm running a procedure other one wrote. It has a input parameter EndDate VARCHAR(10) and in the st…
5 replies
I have a situation where I'm querying two tables, each that has up to two hobbies listed. The first…
92 replies
Viewing 15 topics - 7,921 through 7,935 (of 10,647 total)
You must be logged in to create new topics.