Topics
Started by
Posts
Last post
Hi, I have a frustrating problem whereby I am using a Select statement to output to a (new) text fi…
4 replies
hi, I'm trying to make a count on the basis of a bit value. SELECT COUNT(CASE WHEN ISWaiting = 0 T…
2 replies
I working on a modernization of the Tally Table article which, of course, will include some "CSV Sp…
44 replies
Hi all, I know WHAT inner joins are, but I just wanted to get refreshed on their use with 3+ table …
1 replies
Hi, For Eg, This is table structure, Create Table voucher ( VoucherID int, LocationID in…
2 replies
Howdy folks. I'm trying to figure out a way to rowset multiply. I can sum, avg, checksum, and I've…
3 replies
Hi, I made a simpel script for some collegue to get some info out of the sql database. now i want i…
16 replies
Hello, I am executing few Select statements. I have done this previously and the queries were runni…
7 replies
Hello I have a stored procedure that selects from a bunch of tables. The database name and where cl…
2 replies
Greetings again Super Experts: I have a file that is converted from mainframe to a .txt file. After…
12 replies
What am I doing worng...? I have several SQL training scripts that use variables this way and they …
4 replies
I have a list of dates and account strings over a 3 year period. Here's a brief example: select ef…
5 replies
Hi, In a temporary table (Table_A) I have several instances of duplicate records. When loading thes…
5 replies
Hi all, I am trying to run a query against a single table to determine hierarchy in Employee table …
3 replies
Hello guys, I'm using a SELECT query to join data from two different databases that reside in the s…
16 replies
Viewing 15 topics - 2,971 through 2,985 (of 12,230 total)
You must be logged in to create new topics.