Topics
Started by
Posts
Last post
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
Hi, I am generating the HTML using the XML PATH query, which is happening using the below mentioned…
9 replies
173164 | Tomas174498 | Hp175809 |Lg -- return all data all okay not have any problem now i want s…
4 replies
so I have an account string I need to separate for interfacing to another third party system. …
15 replies
this is my from where SQL statement FROM [HYP_FDMEE].[dbo].[TDATASEG] with (NoLock) LEFT JOIN [blac…
6 replies
Viewing 15 topics - 196 through 210 (of 10,647 total)
You must be logged in to create new topics.