Viewing 15 posts - 196 through 210 (of 1,048 total)
bitbucket-25253 (9/2/2013)
Thanks for a nice question - good way to start a work week
+1 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 2, 2013 at 10:57 pm
prepare yourself and see where you stands...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 2, 2013 at 3:43 am
create table #TableTools (id int identity(1,1), name varchar(15), tools varchar(15))
insert into #TableTools values
('mike', 'walker')
,('mike', 'cane')
,('steve', 'walker')
,('mitchel', 'cane')
,('dave', 'cane')
,('mitchel', 'none')
;WITH CTE AS
(
SELECT NAME, ROW_NUMBER() OVER (PARTITION BY NAME ORDER BY NAME)NOS
FROM...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 2, 2013 at 3:01 am
hany.helmy (9/1/2013)
Maybe this is the easiest question ever in SSC; thanx Steve 😀
+1 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 1, 2013 at 11:24 pm
the information that you have provided is not sufficient for us to understand what you want to achieve?
can you please some more detailed information like what output you want from...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 1, 2013 at 11:22 pm
Erland Sommarskog (8/30/2013)
SELECT quotename(s.name) + '.' + quotename(o.name), o.typeFROM sys.objects o
JOIN sys.schemas s ON o.object_id = s.object_id
WHERE o.type NOT IN ('S', 'IT')
This will lists all objects...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 1, 2013 at 11:20 pm
what result you are getting with this query and what output you want?
please provide some more detailed information
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 1, 2013 at 11:15 pm
can you please post the query that you have written so that we can see what you have tried and help you
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 1, 2013 at 11:14 pm
you can use BULK INSERT for loading data from a text file into SQL server table.....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 1, 2013 at 11:11 pm
Can you please post the table structure and resultant output that you want
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 31, 2013 at 3:55 am
Can you please post the code what you have written with DDL statment of CREATE TABLE, DDL stament of sample data in form of INSERT statment.....
You can folow the link...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 30, 2013 at 6:29 am
magwitch (8/30/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 30, 2013 at 6:25 am
kapil_kk (8/30/2013)
you are getting error because before statement
FROM sys.databases WHERE name not in ('master','tempdb','model','msdb','ReportServer','ReportServerTempDB')you haven't use SELECT statement and columns names which you required in your output
I apologize for...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 30, 2013 at 5:53 am
magwitch (8/30/2013)
Thanks but where would you put the SELECT in?
Before FROM keyword....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 30, 2013 at 5:46 am
you are getting error because before statement
FROM sys.databases WHERE name not in ('master','tempdb','model','msdb','ReportServer','ReportServerTempDB')
you haven't use SELECT statement and columns names which you required in your output
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 30, 2013 at 5:33 am
Viewing 15 posts - 196 through 210 (of 1,048 total)