Topics
Started by
Posts
Last post
Hi Gurus.. I am trying to write a sql case statement that will filter as follows: My lack of syntax…
5 replies
Hi experts, I am having trouble in writing a crosstabs or 'pivot' T-SQL query from a Sales_Summary_…
3 replies
I wan't expert opinions on this particular statement. In my database I have 10 tables. The PK in on…
8 replies
Hello, I am working on a project for a company that needs a report. The report is using a tab…
7 replies
I am having a problem while doing a "LEFT OUTER JOIN", where I am getting a value (say "Y") e…
3 replies
Does any one know a good way to migrate the feature of packages in Oracle for use in SQL2000? In sq…
5 replies
hello I have a table with 3 fields A,B,C: example A &nbs…
2 replies
Hello, MSSQL2000/SP4 I get a different record count when I use Query Analyze (ie: select count(*) f…
3 replies
Brain has gone blank.... how would you do a select distinct but where you want distinct values from…
3 replies
Hello Friends, I need a small help in extracting data from one table Details. There is a skillset m…
2 replies
Hi, I was wondering if someone could help me out. I would to get date in the following format…
2 replies
I am using the follwing trigger where it updates all records in lastmodified column to curren…
4 replies
hi all how can i execute a local package i made in DTS using sql ( i want to execute the package i…
9 replies
I need to create a "Pivot" table similiar to the Access Pivot Table. I have 2 tables, Code_Descript…
4 replies
I have three instances of sql server 2000 on three boxes. WE collect the data on box1 and box2 and …
1 replies
Viewing 15 topics - 8,251 through 8,265 (of 17,082 total)
You must be logged in to create new topics.