|
More site info...
New to SQL Server | Forum profile
|
|
Forum profile page for New to SQL Server on http://www.sqlteam.com.
This report page is the aggregated overview from a single forum: New to SQL Server, located on the Message Board at http://www.sqlteam.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "New to SQL Server" on the Message Board at http://www.sqlteam.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on New to SQL Server:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
78
|
344
|
869
|
|
Post:
|
262
|
1,003
|
2,541
|
|
|
New to SQL Server Posting activity graph:
|
Top authors during last week:
user's latest post:
BCP queryout
Published (2009-11-13 15:22:00)
> let me get this straight 1. You are bcping data out of mobile laptops to a central file location 2. You are then bcping that data into a central sql server database 3. Then you combine all the data into 1 table How does the file get to a central location Is it on a network? If it is, why can't you just use T-SQl and put the data into the central database to begin with? Brett 8-) Hint: Want your questions answered fast? Follow the...
user's latest post:
delete records from data base
Published (2009-11-14 18:01:00)
> The question is: How to decide which records are the last 10? No, you're never too old to Yak'n'Roll if you're too young to die.
user's latest post:
Retrieving records for the...
Published (2009-11-13 02:12:00)
> quote: Originally posted by kiesh i am using mysql select * from tablename where datecolumn>=current_date() and datecolumn<adddate(current_date() ,interval 1 day) Madhivanan Failing to plan is Planning to fail
user's latest post:
delete records from data base
Published (2009-11-14 23:09:00)
> DELETE FROM YourTable WHERE YourID < 551662 Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."
user's latest post:
truncate and delete issue
Published (2009-11-13 08:24:00)
> any trigger on the table ? KH Time is always against us
user's latest post:
Help in Query
Published (2009-11-12 16:49:00)
> I updated the profile, but will others be able to see the details of me?
user's latest post:
SELECT * TO XML OUTPUT
Published (2009-11-13 09:26:00)
> have a look at for xml feature in sql. that should give you a start
user's latest post:
truncate and delete issue
Published (2009-11-13 13:06:00)
> I am talking to my DBA even he is surprised, may be ssma has cached records for the large table, as I have loaded this table partially at first go, due to failure I need to restart the process, hence was trying to truncate/delete existing records and upload the table. I dropped the table, and when I recreated only structure using ssma, surprisingly it has records in it.
user's latest post:
Select statement help? DATEPART...
Published (2009-11-12 04:25:00)
> I'm editing a stored procedure, which feeds the Web-based reports. At the top of the stored procedure is... @StartDate datetime, @EndDate datetime, Later there is... declare @TimeZoneId int execute @TimeZoneId = [TimeZoneAdjustReportDates] @TimeZone, @StartDate output, @EndDate output These two values are passed via the web front end for the reports I believe, as you can report on pre-set periods (this week, this month, last month...
|
|
|
|
Latest active threads on New to SQL Server::
Started 1 day ago (2009-11-15 07:37:00)
by Sitebuilders
>
Someone has an answer to this issue ?
Started 1 day ago (2009-11-15 07:19:00)
by senthil_nagore
>
You can take take Script and run it in 2005, but data can't be copied! Senthil.C -------------------------------------------------- ---- [Microsoft][ODBC SQL Server Driver]Operation canceled http://senthilnagore.blogspot.com/
Started 4 days, 16 hours ago (2009-11-11 15:51:00)
by tkizer
>
Could you at least show us what you have tried? Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."
Started 3 days, 7 hours ago (2009-11-13 00:32:00)
by bklr
>
r u using mssql or oracle? if ur using oracle use sysdate function
Started 1 day, 23 hours ago (2009-11-14 09:03:00)
by webfred
>
Hahahaha! Select DISTINCT in combi with Row_Number() No, you're never too old to Yak'n'Roll if you're too young to die.
Started 1 day, 23 hours ago (2009-11-14 08:35:00)
by webfred
>
You are joining dbo.INV1 twice so you have to give different alias names for them. For example you can do it like this:
dbo.INV1 as Inv1_Doc ON dbo.OINV.DocEntry = Inv1_Doc .DocEntry LEFT OUTER JOIN
dbo.INV1 as Inv1_Base ON dbo.ODLN.DocEntry = Inv1_Base .BaseEntry
Now you have use that aliases in your select list and WHERE-clause instead of dbo.INV1 ...
|
|
Hot threads for last week on New to SQL Server::
Started 3 days, 20 hours ago (2009-11-12 11:34:00)
by X002548
>
Well let's get even simpler What version of SQL Server are you using What is the name of the table and column you are looking at? Brett 8-) Hint: Want your questions answered fast? Follow the direction in this link http://weblogs.sqlteam.com/brettk/archive/2005/05/ 25/5276.aspx Add yourself! http://www.frappr.com/sqlteam
Started 4 days, 16 hours ago (2009-11-11 15:51:00)
by tkizer
>
Could you at least show us what you have tried? Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."
Started 2 days, 23 hours ago (2009-11-13 08:23:00)
by russell
>
when you delete, what message is returned?
Started 2 days, 21 hours ago (2009-11-13 10:43:00)
by tkizer
>
You need to specify the -S switch so that it knows what SQL Server to use. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."
Started 6 days ago (2009-11-10 07:23:00)
by madhivanan
>
where ( [DomainLog].[StartTime]>=dateadd(day,datediff(day, 0,getdate()),'8:30') and [DomainLog].[StartTime]<=dateadd(day,datediff(day, 0,getdate()),'12:30') ) or ( [DomainLog].[StartTime]>=dateadd(day,datediff(day, 0,getdate()),'13:15') and [DomainLog].[StartTime]<=dateadd(day,datediff(day, 0,getdate()),'17:00') and ) Madhivanan Failing to plan is Planning to fail...
Started 6 days, 23 hours ago (2009-11-09 08:22:00)
by ashishashish
>
let us see your query. iF theRe iS a wAy iN tHen theRe iS a wAy oUt..
Started 5 days, 19 hours ago (2009-11-10 13:04:00)
by visakh16
>
update a
set a.public_id = b.public_ID
from userlist a
inner join member. dbo.members b
on a.board_ID = b.member_number
where a.board_ID is not NULL
Started 4 days, 2 hours ago (2009-11-12 05:16:00)
by khtan
>
fnFilterString KH Time is always against us
Started 4 days, 9 hours ago (2009-11-11 22:43:00)
by russell
>
First, this is a MS SQL Server forum. This is different from mySQL. You may try posting at mysql.com forums. But, here's a few answers to your questions: 1. Relational Theory. This essentially means normalizing your data (and creating relationships between data sets -- tables). THAT means, no duplication of data in your tables (or at least as little as possible). ...
Started 3 days, 7 hours ago (2009-11-13 00:32:00)
by bklr
>
r u using mssql or oracle? if ur using oracle use sysdate function
|
|
Size: 236 bytes
