Topics
Started by
Posts
Last post
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
Hi, I having a table called TableA, the record in TableA already in order sequence as below:- ID …
3 replies
Hello~ I'm sure there's a very simple solution, but it seems to be eluding me -- I have a db applic…
3 replies
Hi There, I have been play with some scripts and getting a bit stuck. So I have a table called char…
17 replies
Viewing 15 topics - 1,576 through 1,590 (of 1,808 total)
You must be logged in to create new topics.