Viewing 15 posts - 31 through 45 (of 284 total)
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 26, 2017 at 8:10 am
The long forgotten PATH command from MS-DOS days is very much alive still in Windows, just not as accessible. I bet that the path for the 100 is before the...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 10, 2017 at 3:32 pm
WebTechie (1/4/2017)
Hello,We are doing a migration and need to import in batches of 500 rows. The table that we are migrating has 60,000 rows.
Just curious, but are these new...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 10, 2017 at 3:17 pm
Chris Harshman (1/5/2017)
SELECT TOP 1 OffSet, Amount
FROM...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 5, 2017 at 1:04 pm
SQLserver_learner (12/30/2016)
WITH LatestDates AS (
SELECT
[MDDS01_MDD_STORE_GU_D]
,[MDDS01_CATALOG_D]
,[MDDS01_LAST_UPDT_S]
,ROW_NUMBER() OVER (PARTITION BY [MDDS01_CATALOG_D] ORDER BY [MDDS01_LAST_UPDT_S] DESC) AS...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 30, 2016 at 7:12 am
jason.shaw (12/28/2016)
FROM <TABLENAME>
WHERE ACCOUNT_NUMBER IN ('100', '150', '175')
and once those acct numbers are selected per query above, I need to change an field value for each...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 28, 2016 at 2:10 pm
joanna.seldon (12/7/2016)
Hithanx amazing..worked a treat
Kind Regards
Just curious, but which solution worked for you?
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 7, 2016 at 7:23 am
joanna.seldon (12/6/2016)
I am trying to write
Where (coalesce(A.Department,B.Department) <> '1', NULL)
I wish to bring back rows of data for Department <> '1' , and Null
Can you try:
Where Coalesce(A.Department,...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 6, 2016 at 8:17 am
tacy.highland (12/2/2016)
We have time saved in our db in a seconds after midnight format and need to convert it to a regular AM/PM time format. Currently we use...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 2, 2016 at 12:31 pm
I have edited my earlier post to include create and insert statements for table2.
I must be dense, but your explanation and your example output do not make sense to me....
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 18, 2016 at 7:50 pm
knight944 (11/18/2016)
table1
(
ID CHAR(10)
SUB_ID CHAR(3)
DESC CHAR(100)
)
table2
(
ID CHAR(10)
DESC CHAR(100)
)
I would need to look through table 1 so that for every...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 18, 2016 at 3:21 pm
Please read the article contained in the link in the signature line. It will show you how to post DDL and data so that we are not guessing as to...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 18, 2016 at 2:03 pm
Merge
or
Insert Table1 (columns)
select columns
from table2
where not exists (select 1 from etc. . .)
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 18, 2016 at 1:51 pm
sharonmtowler (11/18/2016)
I have a query I am using in an ssrs report. It works great when run on the sql server. Once I put it in SSRS I get...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 18, 2016 at 11:10 am
GilaMonster (11/8/2016)
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 8, 2016 at 8:16 am
Viewing 15 posts - 31 through 45 (of 284 total)