Topics
Started by
Posts
Last post
I have a table. Structure in script below. I have to compare and see if for a job id if the order o…
3 replies
Background: I have two tables. Tests and Grades. For each Tests record there are many Grades; one f…
16 replies
I've read lots of the horror stories about nested views in databases where they're like 7 levels de…
2 replies
I know how to generate fake data (thanks to Jeff Moden's articles!)... the problem is that I'm tryi…
4 replies
Here's my data... I am trying to return total days in status for each status. I was suggested to…
1 replies
By: Jeff Moden
Here's my data... I am trying to return total days in status for each status. I was suggested to…
1 replies
By: Jeff Moden
I want to group the data by consecutive months (mydate). how can i do this? Data looks like this:…
6 replies
I have a linked server pointing to an Oracle instance using OraOLEDB.Oracle. The table contains a…
24 replies
I want to get the sum and I want to get the sum of only last month for VenNum by FiYr and DocDte. …
3 replies
insert into NewKms8081..members SELECT (select u2.Id from SecurityKms8081..users u2 join S…
2 replies
Not sure I have this 2nd left join correct. I need to grab the closest #Deptvalues.DeptDate and #De…
3 replies
Hello everyone, I hope you can help me. I have a table with measurement data. Each measurement has …
2 replies
Given the following table and query, this will return any records(based on message_id) that have ti…
2 replies
Sample query reply appreciated Getting the following error: Conversion failed when converting the v…
5 replies
Hello everyone, I need your help. I have a “datetime” column (data type is Varchar(64) )with th…
5 replies
Viewing 15 topics - 1 through 15 (of 308 total)
You must be logged in to create new topics.