Viewing 15 posts - 1,486 through 1,500 (of 8,760 total)
April 26, 2018 at 2:15 am
We have a datetime field where date time is saved in below format.
Apr 19...
April 26, 2018 at 12:55 am
Quick suggestion, have a look at these two articles, Tally OH! An Improved SQL 8K “CSV Splitter” Function and Reaping the benefits of the Window functions in T-SQL
April 26, 2018 at 12:33 am
April 24, 2018 at 11:54 pm
Trying to setup a while loop to go thru each record on a temp table...
April 24, 2018 at 10:26 am
April 24, 2018 at 10:23 am
I'm new to SQL and I have been trying to learn how to read...
April 24, 2018 at 12:38 am
This should get you passed this hurdle
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @TXML XML = '<root>
<v_R_System>
<ResourceID>33558284</ResourceID>
April 24, 2018 at 12:25 am
This can be simplified with the concat function.
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @PERC DECIMAL(6,4) = 1.25;
SELECT CONCAT(CONVERT(INT,@PERC...
April 21, 2018 at 12:23 am
I have a weird situation that as from yesterday one of our queries started changing...
April 20, 2018 at 5:23 am
Can you post the queries and the execution plans?
😎
April 20, 2018 at 5:06 am
April 19, 2018 at 6:36 am
April 19, 2018 at 3:14 am
You can do the schema validation in SQL Server, have a look at this article.
😎
April 19, 2018 at 2:08 am
Viewing 15 posts - 1,486 through 1,500 (of 8,760 total)