Topics
Started by
Posts
Last post
Hi All, I basically from Oracle platform. Could you please tell me what is the alternatve function…
2 replies
Hi Experts. I have this query which count how many sellers who sold at least one item from a catego…
9 replies
I am trying to do what I thought was a simple query against a table, SELECT * from dbo.mytable …
15 replies
I have most of a veiw written but I’m not sure how to compare two dates. I have a subscription.pai…
5 replies
Does anyone have any words of advice/code snippets etc etc on how to dynaically create insert state…
6 replies
I have a column that is numeric(9) and can have values up to 999999999999. I need to add 0's to pad…
2 replies
I'm having problems with the openrowset command in SQL Server 2005 stated below... 1. Create a new …
5 replies
First of all hi everyone..Happy New Year. Haven't logged in since last year! OK, today's dilema: I…
3 replies
Access DB (external/ remote data source) --> SQL DB My system is such that I have to constantly…
12 replies
I've been tasked with generating a dataset that returns the number of active customers per month, g…
4 replies
I need to get output from a standard query like SELECT * FROM TABLE to come out like the followng: …
9 replies
I have a view called view_badge and a table called t_badge. Both the table and the view have the sa…
5 replies
I have a view called view_badge. The sql to create this view is displayed below. The following line…
1 replies
Hi what is the diff b/w UNION and JOIN .Please explain with examples Binu
2 replies
If I group by MyTableID how do I get 1ML, 2ML, 3ML and 4ML into the output? The ML columns are dat…
8 replies
Viewing 15 topics - 10,936 through 10,950 (of 12,234 total)
You must be logged in to create new topics.