Topics
Started by
Posts
Last post
Hello, I am trying to generate a monthly report for sql database backup job. Is there a script tha…
7 replies
Hello All, I have one t-sql related question. I have one table which contains hierarchy data in fol…
2 replies
I am trying to show how many employees were hired in each department by startyear (2001, 2002, 2003…
5 replies
Is it possible to combine the Rows returned from a SQL running within a Cursor? DECLARE sla_cursor …
11 replies
I am trying to pivot and get both a summary and detail result set. The detail would get all r…
3 replies
I am trying to simplified a routine process I write into queries using a user defined function inst…
2 replies
Is thisselect (select top 1 organisation from sysfile) as org,* from area1More efficient than a joi…
3 replies
I get the following error with the following code. This code is stripped from a larger piece …
17 replies
I have a query that is doing some grouping and I needed to concatenate a column so I don't lose the…
2 replies
my table is simple it has 1,000's of rows. one row is the account balance in U…
30 replies
Hi,How below query works? Can any one explain?create table #temp1(id int,name varchar(10)) insert i…
2 replies
Hi AllI'm trying to help a colleague optimise an SQL query that looks for parts of a persons name a…
15 replies
I can't seem to get the log file to auto shrink.It is set to auto shrink in the properties, but doe…
4 replies
Hi, all! Over the past year, we've been migrating our reporting databases from 2000 to 2008R2. We'…
15 replies
hi,my SQL knowledge got a little bit rusty. Trying with Group By failed, so this is my question: CR…
15 replies
Viewing 15 topics - 196 through 210 (of 10,635 total)
You must be logged in to create new topics.