Topics
Started by
Posts
Last post
Hi, I recently stumbled over your articles on using CTEs and wanted to start using them myself. How…
1 replies
create table test(c1 int, c2 int) create unique index idx_test on test (c1) insert test values (1, …
4 replies
HI ALL, I have a a table which contains 3 columns, column 1 is an identity, column 2 contains a sta…
8 replies
hi, Need some expertice or advice, I am trying to SUM my case statement where I have COUNT functio…
4 replies
I have a query that returns a list of Purchase Orders for each supplier. The query is to be used in…
1 replies
I want to return records where EffectiveDate is greater than 30/09/2009 (30th September 2009). I ha…
4 replies
i am a newbie in sql server can someone help me with this consider some inventory data: AssemblyKey…
3 replies
I have been asked to write a report that amongst other things returns the TOP 5 Suppliers based on …
3 replies
I thought I had seen a way to do this before, but I can't seem to find it now. What I have are a s…
4 replies
Here is a table: CREATE TABLE Employee ( EmployeeID int NOT NULL PRIMARY KEY, EmployeeName var…
8 replies
Hi. I have been playing with two versions of a query. Both return cost relative to batch 100%. The …
5 replies
hello experts, I have two tables: A Aid ProductID ProdQty ProdBalanceQty 1 1 100…
2 replies
Hello, I have a timetabling application, out of which I need to calculate the amount of time tutors…
3 replies
Hi, I need a TSQL to store and retrieve pdf & jpg file into SQL Server tables. Is there a way?…
2 replies
Hi, To whom it may concern: I have an issue regarding batching a rows/records by 50. Im using sql s…
4 replies
Viewing 15 topics - 5,161 through 5,175 (of 12,230 total)
You must be logged in to create new topics.