Topics
Started by
Posts
Last post
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
Hi Hi I want to create a sql script which loops through a column (segment) and transforms the valu…
9 replies
Hi Everyone I have a merge statement which ends with the following WHEN NOT MATCHED BY SOURCE THE…
10 replies
Viewing 15 topics - 3,061 through 3,075 (of 10,635 total)
You must be logged in to create new topics.