Topics
Started by
Posts
Last post
Hi, I need help in writting a T-SQL query. I have attached script for the schema and sample data. I…
5 replies
Hey, I've been having some difficulties writing a query for an MI report. Basically, the report is…
5 replies
Hi guys, I have a conundrum that I would really appreciate some help with... Basically I need to ex…
8 replies
Why is it that 1 divided by any number larger then 1 always returns a 0? How can I get around this?…
9 replies
A developer needs to convert a string 'Thu Aug 5 12:14:49 GMT-0400 2010' into a date format. Does …
2 replies
Hi I would like to create a select statement which abstracts certain information from a table call…
6 replies
Hi, I'm a beginner with t sql in sql server 2005. I've try to create a simple script who creates so…
3 replies
SELECT RECID,BranchRECID,ScheduleContinueS,EndDate FROM tblBranch_Schedule WHERE DATEDIFF(DAY,Start…
1 replies
Hi folks, I have a strange request which i don't know is possible. Have looked up replace function …
12 replies
I read recently some bad results that can be caused by using nolock. I have quite often used nolock…
12 replies
Dear All, I have 3 tables having some 10 fields of each i need to compare the each column with anot…
2 replies
Hello Experts, I have a table named tblKPIResults.Table columns are like below: CREATE TABLE [dbo].…
2 replies
Hello all, I've researched a lot but can't figure out a proper way to do this. Please see attached…
3 replies
I need a procedure to cycle through every database on the server and display the user permissions f…
6 replies
I have a table listing a bunch of things. I have a sql query I wrote that will give me the data I w…
11 replies
Viewing 15 topics - 1,966 through 1,980 (of 12,234 total)
You must be logged in to create new topics.