I have a DB with a field defined as:
dag_text text allow nulls
I have an hexadecimal value (0x15) p…
18 hours, 34 minutes ago
By: Phil Parkin
I can't remember ever trying this before, but I have need to do it now. I need to update a specific…
2 days, 9 hours ago
By: Jeffrey Williams
So I want to store the difference in milliseconds between rows in a column
ID , Label,…
2 days, 19 hours ago
Right now I have two queries as shown below:
SELECT D.DocumentID AS [Document ID], D.Filenam…
3 days, 13 hours ago
I have a table with ~500K rows in it. Here's a sample of the data
BegVal EndVal Volume Prefix Paddi…
1 week, 1 day ago
I have included the DDL to re-create the 2 tables in this examples. I can't post the actual DDL so …
1 week, 2 days ago
i found some script to list out the primary ag groups in servers in powerhsell.
but the results…
1 week, 6 days ago
By: Site Owners
I found a glitch in one of my reports.
Its due to events spanning the hour difference when a time z…
2 weeks ago
By: Steve Collins
We have a report that returns a set of aggregated data and in some cases i've duplicated record…
2 weeks, 2 days ago
My requirement is to split columns [Owner],[PersonAttending],[Type] into multiple rows if more …
2 weeks, 4 days ago
After reading many posts, this is what I learned.
SELECT MIN(StartDate) AS MinDate FROM Schedule WH…
3 weeks, 2 days ago
I need a help in writing a bit tricky logic to write, I will explain the scenario with…
1 month ago
When is it kosher to use calculated columns in SQL Server? On complex calculations that only need t…
Can you please help with below code.
#FINALTable is the target table that needs appen…
I have a query that produce a table where I have a list of columns.
Then I choose check what co…
By: Jeff Moden
Viewing 15 topics - 1 through 15 (of 1,288 total)
You must be logged in to create new topics.