Topics
Started by
Posts
Last post
i have a data as below. Price = 25.0 Discount1=10 percentage Discount2=20 percentage Discount3=30 p…
15 replies
How do you return a list of the companies, sales, and month for the top 5 sales for each month wit…
9 replies
I have an Employee table that has a primary key. This key is used in another table for both a Welde…
6 replies
Hello All, I have a insert update procedure where I am getting data from 2 procedures and putting t…
1 replies
I've been coming to this site for years. I've never registered, and I almost always find the answer…
7 replies
In a specific Query, how can you easily identify how long each piece of code is taking? My query is…
4 replies
So I am trying to get the datediff for parameters selected, even though the 2 dates could span 60 d…
5 replies
In SQL, these items sort this way INV175 INV190 INVB03 INVB04 On the IBM iSeries, they sort. INVB03…
2 replies
Hi, Is there a way to create a view out if this query below? DECLARE @query nvarchar(max) SELECT @…
8 replies
Hi I have the following Syntax: DECLARE @MyXMLString XML SET @MyXMLString = '<items> …
6 replies
I was reading one of Brent Ozar's posts about SSMS, and he was talking about "never use the sa/admi…
11 replies
I really like Steve Jones' editorial today, Carefully Giving Normal Users Security Permissions. I'v…
7 replies
Hi could anyone please shed some light how this sql works. i.e. how the cursor is being used in th…
7 replies
Hi, I tend to copy data from Table1 to Table2. Table1 will always being refresh & trunca…
6 replies
Hi, relatively new to SQL development so hoping this isnt a silly question but here goes... If you …
7 replies
Viewing 15 topics - 1,546 through 1,560 (of 1,782 total)
You must be logged in to create new topics.