Topics
Started by
Posts
Last post
Is it more efficient to search on an int than a nullable DateTime? I have a table where I can choos…
4 replies
<!--more--> Attachments:You must be logged in to view attached files.
3 replies
Tbl Attachments:You must be logged in to view attached files.
7 replies
I have a disagreement with the programming team on an app that I designed. It's not a major disagre…
11 replies
I've read lots of the horror stories about nested views in databases where they're like 7 levels de…
3 replies
I have a table. Structure in script below. I have to compare and see if for a job id if the order o…
4 replies
Background: I have two tables. Tests and Grades. For each Tests record there are many Grades; one f…
16 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
Here's my data... I am trying to return total days in status for each status. I was suggested to …
1 replies
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 ab…
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
Viewing 15 topics - 91 through 105 (of 401 total)
You must be logged in to create new topics.