Topics
Started by
Posts
Last post
Hi, I have this function called fn_GetTimedKey() when I run it in my SQL2005 environment it works f…
2 replies
Hi all how do I query datepart to include month also when passing a variable from my app. My attemp…
1 replies
SQL Server 2008 R2 Two computers: MachineOne and MachineTwo Two instances of SQL server,: MachineOn…
1 replies
Hi I have a script, which when ran inserts values from multiple tables into another table, then exe…
4 replies
I want to reference a previous group's max date and compare it to the date on the current record. M…
5 replies
Hi All, can anyone help shed some light on the following issue... SQL Server 2008 SP. My SP returns…
6 replies
(SQL SERVER 2008 R2) Hi guys, I need some help on how to retrieve Hierarchy in a table. In this cas…
11 replies
Hi, is there a difference in terms of performance?. The execution plans are identical. Does an inde…
2 replies
I am trying to create a Function that I can pass 4 data points (Lat/Long) to and have it calculate …
1 replies
hello all, Here's what I got: Table 1 structure: Id int, controlIDvarchar(13) data: 1,1…
4 replies
Our lead wants me to maintain two different version of VIEW for DEV and PROD. We're building custom…
3 replies
Hello, I have 1 table with some fields in it. Two of the fields are important to me. I need to chec…
3 replies
Hi, Below query displays result as 0.00 but i want to show as 0.73 SELECT ROUND(CAST (22/30 AS deci…
2 replies
What would be the best way to write a sql query where the result set contains a group by where one …
3 replies
Is there a round down function?
4 replies
Viewing 15 topics - 3,061 through 3,075 (of 10,647 total)
You must be logged in to create new topics.