Topics
Started by
Posts
Last post
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
Ok. I have a piece of Dynamic SQL that WAS working until I added one more variable. Here is the SQL…
7 replies
Hi All, I need help about writing the sql as below. I find a StartDate and EndDate with Case functi…
6 replies
Hi. I wrote this sql as below. But it doesn't work as I want. I want to filter by with dbo.fDetermi…
3 replies
I have a db recently migrated to SQL Server which I must test. Each table has many triggers. I am…
2 replies
Viewing 15 topics - 10,936 through 10,950 (of 12,230 total)
You must be logged in to create new topics.