Topics
Started by
Posts
Last post
Hi All, I need to calculate running total (totalInterestedPaid) for the following temp table (#tmpI…
4 replies
Is there a way to select the getdate() function or any other function and have it return a value th…
3 replies
Hello All, I'm facing a problem with the below query that I'm using in an SSRS 2005 report for MS C…
8 replies
Hello everybody, i work with sql server 2005 and i'm a beginner with t sql. I must to transform a t…
3 replies
We are not allowed to use xp_cmdshell for security reasons. I currently extract data (real-time) fr…
3 replies
Hello. I don't see an easy way to return rows that have less than 2 occurances of a character withi…
2 replies
Can any one help with below query. i am getting error saying that Msg 8120, Level 16, State 1, Lin…
2 replies
When you run a sql statement, in Server Management Studio, it tells you how many rows and how long …
2 replies
I have output for scores that have 2 decimal places (all zeros). I need to remove the decimal place…
9 replies
Hi, I have a tree structure represented by a simple table that references itself: CREATE TABLE [db…
19 replies
Hi all, Very basic question. I was reading the MCTS 70-433 training kit book from Microsoft, and fa…
1 replies
Hi Guys I have a column with the figures which have 4 decimal points. I want to trim them to two de…
27 replies
Hi All In My project one table my old employees using following format id generation.Hoe…
6 replies
Hi all, Got the following problem situation: CREATE TABLE #Test ( ID INT, Date DATETIME ) CREATE…
3 replies
The problem is to extract a random sample of 3 accounts for each staff person. In reality, my tabl…
2 replies
Viewing 15 topics - 886 through 900 (of 12,234 total)
You must be logged in to create new topics.