Topics
Started by
Posts
Last post
Example: Run a query that finds the following: User 1 has 5 quiz results User 2 has 3 quiz results…
7 replies
I have similar query in SQL2000 and does not fail, but in sql 2008 r2 fail. But if you put cast(con…
4 replies
Hi, As below query order by - sorting cost is 78%, pls. suggestion me how to reduce the cost? attac…
15 replies
Hi Guys I have a data where there are parent and child product. Each parent has got a unique code(P…
21 replies
I'm not sure how to ask this. This is very common. Assume you have an invoice and two possible addr…
2 replies
Hi, This has to be a fairly general question because I am working with a linked server that I don't…
3 replies
Hello, My table is like this: ID int Ref Varchar(10) CreatedOn datetime State Varchar(10) I need to…
7 replies
Hi, I was wondering if there is a way to optimize something like this: SELECT b.id, CAST…
6 replies
Hi all, I've got a sproc that we are migrating from SS2K that uses the reserved keyword 'Pivot'. I…
14 replies
Hi this is my DDL for this question. Drop Table TemplateItemTest1 CREATE TABLE [dbo].[TemplateItemT…
5 replies
Hi I have one stored procedure which in turn executes 3 more sps in it. All the 4 stored procedure…
18 replies
Hello Everyone I am working with some data that contains string text. Not an odd type of thing. I h…
5 replies
Is it possible to use Xpath in a query to get child parent relation ship using XQuery. If I use EXE…
4 replies
I need to check the library used by several stored procs that extract data from a remote IBM iSerie…
3 replies
Hi all, I want to save my XML to another database server location. Is it possible? Here is the code…
4 replies
Viewing 15 topics - 2,446 through 2,460 (of 10,647 total)
You must be logged in to create new topics.