Topics
Started by
Posts
Last post
Dear All, I have table where i need to do the column and row concatenation for some of the fields. …
1 replies
HI, I have a query stated below. I am getting syntax errors. select tot.zipCode, count(*) from ( (…
1 replies
Hi below returns a list of unique products (type purchased, purchased assembly) that have been purc…
4 replies
I need to return the most recent blog post in a particular category. Similar question: http://www.s…
5 replies
Join these three together and get unique account from third table: table1 userid name 1 joe…
9 replies
How do I get rid of the column names on my sql results? I'm trying to out put to a file and this i…
14 replies
Hi Friends, I am having two tables that are likely same name and unfortunately i have run a simple …
5 replies
Here is the situation: I have multiple events with start and end dates. I've been asked to find the…
5 replies
Hello Friends, I am having a table Item_Master that are having more than 2 crore rows and the stru…
3 replies
Hi All, I am getting result set for the below query SELECT CAST(SUM(CASE WHEN S.TAXABLEAMT <=2…
2 replies
Hello, I am creating a csv list in SQL 2000, this is the key here. I can't use for xml path :(. Sa…
4 replies
When I run the following statement, I receive the error message: Cannot insert the value NULL into …
5 replies
Developer gave me failing sql. Part of the sql does a convert of data that is varchar to money. Th…
1 replies
Hi, I know this a uber-newbie question, but for some reason, I cannot figure it out. I have a simpl…
4 replies
Hi, While I’ am running the below query select 456 & 16 I got the result as 0 . Could…
3 replies
Viewing 15 topics - 2,416 through 2,430 (of 12,234 total)
You must be logged in to create new topics.