Topics
Started by
Posts
Last post
Hi all! I have a MySQL linked server (MYSQLLNKD) in my SQL Server 2005. I need to get the xml outpu…
7 replies
I am writing a stored procedure, wish to pass in @DBName which can used for my declare cursor selec…
10 replies
I am trying to figure out how I can get _KEY to be the columns and _VALUE to be the row. I am ass…
2 replies
Here's what I'm trying to do. I have a field in the database that stores up to 9 comma-separated v…
5 replies
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
Viewing 15 topics - 5,161 through 5,175 (of 12,234 total)
You must be logged in to create new topics.