Topics
Started by
Posts
Last post
I'm dealing with healthcare data where a table maintains a list of patient_ids, associated provider…
7 replies
I probably should figure out this by myself, but this is really driving me nut 'cuz I don't see any…
9 replies
Hi Guys, Here are 2 queries - to me, logic dictates that both should return the same result set. th…
10 replies
I have a lot of parameters in a table. I query the database to popuplate dropdown boxes with speci…
2 replies
Given the following sample code, will the identity column [rowseq] assign a number to the inserted …
3 replies
Hello, I have a strange problem: If I run a query in the query window it takes 7 sec, but if I put …
3 replies
I inherited a query and the last part of it looks to send the file to my c drive - queryout "C:\PWC…
4 replies
Hi I need help with calculating a percentage. I have a query like so select gender, ee_occup_levels…
2 replies
Hello, I have a query:select count(1) as Total, Category from manager group by Category order by To…
4 replies
I have a scenario wherein I have to combine two columns into one . Its SQL Server 2005 Below is the…
1 replies
Hi All, Is there a way to open an XML file from a website directly from SQL Server? For example, ht…
10 replies
Hi Guys, having a little trouble with the following func.: select CAST(SUBSTRING(CEFDT, 5, 2) AS va…
7 replies
Hi, I have some code that rebuilds indexes conditionally and uses sys.dm_db_index_physical_stats to…
5 replies
Hello everyone, I have a rather complicated question about SQL Server that I am hoping someone can …
1 replies
Hi I have been trying to deal with a bug in a stored procedure which gives the error of primary ke…
5 replies
Viewing 15 topics - 5,071 through 5,085 (of 12,234 total)
You must be logged in to create new topics.