Viewing 15 posts - 7,861 through 7,875 (of 13,876 total)
I've suggested this before, but I'll do so again as the spam is driving me mad at the moment.
1) Apply additional rules to new users (< 100 posts, say)
Additional Rules...
November 25, 2015 at 9:41 am
With in excess of 600 posts, you really ought to know how to post questions by now.
Please take a look at the best-practice link for advice.
November 24, 2015 at 5:14 am
Hi Jon
Just because a database has been created does not mean that CREATE TABLE scripts cannot. On the contrary, if the database did not already exist, you would find it...
November 24, 2015 at 5:09 am
Minnu (11/24/2015)
hi Team,How to create a view with below logic,
-- want to delete from unify table before insert.
DELETE FROM dbo.Unify
GO
INSERT INTO dbo.unify (PS_code, PS_Name)
SELECT PS_code, PS_Name FROM [dbo].[Unify_HHT]
Views do not...
November 24, 2015 at 3:25 am
GilaMonster (11/24/2015)
Phil Parkin (11/24/2015)
Thank you, SSC, for helpfully encoding my 'less than' symbol 😀
Happens if the and [ /code] are on the same lime. Put a new line...
November 24, 2015 at 1:57 am
I just don't understand what you mean by 'where should I put the message?'
Why do you need to 'put it' anywhere?
If you need it on a Winform, put it into...
November 24, 2015 at 1:38 am
Thank you, SSC, for helpfully encoding my 'less than' symbol 😀
November 24, 2015 at 12:51 am
dt.Rows.Count < 0
If no rows are returned, the count would equal zero, surely? What makes you think that it would be less than zero?
November 24, 2015 at 12:50 am
Sean Lange (11/23/2015)
Phil Parkin (11/23/2015)
cmc123 (11/23/2015)
can someone help me in writting a cursor with following update statements .This statement will updates each database in an instance of SQL .
UPDATE...
November 24, 2015 at 12:47 am
cmc123 (11/23/2015)
can someone help me in writting a cursor with following update statements .This statement will updates each database in an instance of SQL .
UPDATE dbo.Property
SET USERTXT1 =
(SELECT...
November 23, 2015 at 2:52 pm
Your question is not clear to me. Please provide sample data, DDL and desired results in a consumable form, as described in the first link in my signature.
November 21, 2015 at 9:12 am
caojunhe24 (11/20/2015)
try what?
Erm. The hyperlink in my post.
November 20, 2015 at 10:09 am
caojunhe24 (11/20/2015)
I am using M:\Products & Services\Business Planning & Analysis\ProjectOzRawDataFile_DoNotDelete_Atif\RawData\SAPARawData_PatBell in my package not UNC path I guess so if I have to use UNC path I have to...
November 20, 2015 at 8:09 am
John Meyer-239467 (11/20/2015)
November 20, 2015 at 7:39 am
caojunhe24 (11/20/2015)
November 20, 2015 at 7:24 am
Viewing 15 posts - 7,861 through 7,875 (of 13,876 total)