Topics
Started by
Posts
Last post
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
Can you help me with this please... I wrote a query in ms sql n when i execute this it gives xml ou…
2 replies
Ok, so if you want to keep your sanity, it probably would be best not to ask why I need to do this …
5 replies
I have a query and I'm trying to loop through the results; however, I'm only getting 1 result, wher…
41 replies
I have a datecolumn in this format 2009-10-15 16:57:00 in a table. I need to write a query which ta…
6 replies
Viewing 15 topics - 5,071 through 5,085 (of 12,230 total)
You must be logged in to create new topics.