Sponsored Links

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq

Page 1 of 27

Last »

Threads in Forum : microsoft.public.sqlserver.mseq

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Final Reminder - Microsoft Responds to the Evolution of Community What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft... nntp@microsoft.com	09-11-2010 09:56 AM nntp@microsoft.com	0	661
SQL Server Express Hi, Is English Language Query available in SQL Server Express 2008? Can't see how to access it on my current installation :( Thanks! BillAtWork	09-10-2010 06:06 PM Hugo Kornelis	1	209
Primary/Uniqueness Problem Hi All I am going to design hospital database I have a patient table tblpatient(patientid pk,name,age,................) another table that is... Munu via SQLMonster.com	09-10-2010 06:04 PM Hugo Kornelis	1	171
Re: Primary/Uniqueness Problem Munu wrote: -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-mseq/201008/1 Munu via SQLMonster.com	08-31-2010 11:14 PM Munu via SQLMonster.com	0	168
How to get most recent records from table? Hi, I have two tables Person and Employment. Person has 1 row per person, Employment lists that person's job history where each row is an... Siv	08-22-2010 12:17 PM Siv	0	151
which colour are you in the new ghd colour collection? GHD straighteners are top-of-the-line because they are ceramic, which is less harsh to each strand, and they use the most advanced technology. A GHD... zana	07-20-2010 11:42 PM zana	0	238
How to insert a record in the last position of a file? Hello. i need to store a record in the last positon on the file. This file does not require a key field(s) because i neeed that information in the... Mike SÃ¡nchez	07-20-2010 09:03 AM SQL Servant	1	498
Update Dynamic Period End Date I have a table similar to this sample: Product / Factory / DateFrom / DateTo / Cost A / London / 2009-06-05 / 2049-12-31 / 15.50 A / Beijing /... SQL Servant	07-20-2010 08:00 AM SQL Servant	0	163
Left outer join returns results like inner join? I'm really struggling with a query: SELECT TOP (100) PERCENT dbo.tblBlogCategories.blogCategoryName, COUNT(dbo.tblBlogCounter.blogCounterID) AS... Jon	07-20-2010 04:50 AM Jon	0	172
INSERT into inserting only three characters after truncation I was using an INSERT into statement to insert records into an access database which was working alright. However, ever since I am using the same SQL... S N	07-15-2010 12:38 PM S N	0	152
Inconsistent Foreign key referencial integrity Hi, I have a look up table dbo.DecisionReasonCodes, which has a compound primary key, reasonCode ,char(2) and DecisionCode, char(1). I have the... Sang	07-08-2010 03:18 PM Sang	0	1,191
How to get row index in column I explain the problem COL0 COL1 COL2 COL3 COL4 COL5 row1 blabla 37 M X 1 row2 dgdgg ... Nicolas	06-14-2010 06:09 AM Hugo Kornelis	1	743
Query to return multiple foriengn keys from same table I have an SQL database with the following: TableA with ItemID, Fk1, Fk2, Fk3, Fk4 TableB with DescID, description - Where Fk1-4 is equal to a DescID... IncEzed	06-10-2010 05:46 PM Hugo Kornelis	1	472
Green Envy——ghd new limited edition color collection The gorgeous new limited edition colour collection from GHD is on the market ! This collection is designed for all hair-lengths. The lowwest price... ghdfans2010	06-07-2010 08:53 PM ghdfans2010	0	503
Reminder - Microsoft Responds to the Evolution of Community What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft... nntp@microsoft.com	05-21-2010 04:54 AM nntp@microsoft.com	0	465
Finding File Names in a specific directory I am trying to write a procedure in SQL that can load a table with the file names that exist for a specific path. Are there any 'xp_ fileexist'... Stan G.	05-05-2010 07:22 AM Stan G.	0	534
Date time difference complex query not working All, I'm relatively new to SQL server and am having problems writing a complex date/time query. I have a table with a datecreated field and... Julia B	05-05-2010 04:28 AM Julia B	4	743
Differences in Time Calculations I am not sure if this is possible but I can't find a way to use one datetime field in a record to calculate the time difference from record to... Robman	04-29-2010 02:44 PM Robman	0	484
Help to buld complex query I have two tables: Counters:' Every 10 minutes a record is added with updating the counter Data_Hora ID_Contador ... Henrique	04-25-2010 04:31 PM Henrique	0	449
Stored Procedure not executing from .Net SqlClient but does Analyz I have an an exec call that is executed from Sync Services, that is visibly being executed when run a Trace, but does absolutely nothing. If I enable... eekamouse	04-19-2010 06:48 PM eekamouse	0	487
SQL UPDATE Query Is there a simple and effective way to revert an update query after the fact? -- -M Noon Marc Noon	04-07-2010 04:11 PM Hugo Kornelis	1	458
Error Code 0xD59 I keep receiving error code 0xD59 when installing the SQL Server 2005 Express Edition update (KB955706). I have attempted to use the workaround in... CHW	03-14-2010 05:30 PM wshillington	1	1,182
multiple criteria to case statment See the SQL statement below. It is based on a table called datanorm. I have another table called ToUSTART where the DATANORM.ID will join to... Ian	03-06-2010 05:05 PM Hugo Kornelis	1	710
ä¸‹è¼‰å…è²»çš„åç—…æ¯’ 3367 è¨±å¤šæ€§èƒ½å•é¡Œå’Œå®‰å…¨æ€§æ‚¨çš„è¨ˆç®—æ©Ÿé€*æˆæƒ¡æ„ç—…æ¯’ï¼Œæœ€å¥½çš„è¾¦æ³•å°ä»˜ï¼Œé€™æ˜¯å¾—åˆ°æ‰¿èªå’Œé˜²ç—…æ¯’åœ¨è¨ˆç®—æ©Ÿä¸Šå®‰è£æ›´æ–° æ... antivirus gratis	02-02-2010 06:20 PM antivirus gratis	0	586
Descargas - Antivirus Gratis 1839 Muchos problemas de rendimiento y seguridad de tu computador son causados por virus maliciosos, la mejor forma de combatir esto es tener instalado... antivirus gratis	01-29-2010 07:39 AM antivirus gratis	0	482
BEGIN END not working I'm using SSMS with SQL Server 2008 and Windows 7. The following works: CREATE FUNCTION dbo.test (@testin INT) RETURNS TABLE AS RETURN ( SELECT *... Ed	01-28-2010 07:38 AM Hugo Kornelis	4	484
data type mismatch sir/madam, i have two parameters , one for int and one for varchar. In print statement i wrote as PRINT 12 + '12' then it gives 24 as result, but... Neha Bansal	01-24-2010 05:19 AM Hugo Kornelis	1	429
cursor sir/madam, i have a cursor in which i declare two fields, one is int and another is varchar(50). when i print e.g. 1 + 'neha'. it gives me error as... Neha Bansal	01-22-2010 06:36 AM Neha Bansal	0	463
Show Top Value Only I have a single table with 5 fields: READID (key), ID (user identifier), READDATE, TOD (time of day - as INT 1, 2, 3, etc...), CONSUMPTION... Ian	01-01-2010 02:08 PM Russell Fields	1	558
Need hep for a simple query i have 2 derived tables TBL A product code product color stock count production date TBL B product code product color Murat Demirci	12-11-2009 08:25 AM Russell Fields	1	539
Formatting a date Hello, When I want to format a date in a view, I use e.g. CONVERT(Char(20), tblPE_Personen.PE_Geboortedatum, 112) With the CONVERT function, I am... Michel	11-27-2009 08:49 AM Russell Fields	2	598
Searching for data types I have to find all occurrences of varchar(10) fields (table name and field name) in a SQL 2008 database. Can anyone suggest commands/techniques... Stan G.	11-03-2009 05:03 PM Hugo Kornelis	1	484
Query Help Hi all, I have this Table: ID Visit ID CLIENT Date Visit VISIT DONE 1 7 2009-08-02... MacLanca	10-23-2009 05:31 AM MacLanca	4	556
Left Pad month I have a need to left pad the month with 0, can you help me do this? For eg. if the month is January, in the query it returns 1, I want it to return... Alice	10-08-2009 10:17 AM Eruviel	6	682
SQL Parameters Issue I'm having trouble understanding how parameters are used. It looks like this query is supposed to set all the NDSM_DN's to the current value of... BBF	09-21-2009 07:36 AM BBF	0	522
How to perform this simple join I have a problem that I will distill down to a small academic exercise in the hope that someone can answer. I have the following 2... Rabbi Joseph Gordon	09-17-2009 04:54 PM Rabbi Joseph Gordon	1	516
wrong query- URGENT Dear, I have updated wrong query is there any thing to revert back the query or dats I run following update query. update Bulk_SMS_Regular set... saqib ahmad	09-14-2009 11:24 AM Hugo Kornelis	3	536
SQL help Two table Item Table - id, itemlookupcode , description, price, etc Kit Table - id, kititemid (refers to id of item table), kit componentid (refers... Dan-902	09-06-2009 02:57 PM Hugo Kornelis	1	538
create view sorted I have developed the following query; create view MemberList as SELECT TOP (100) PERCENT dbo.tblMemberNameandAddress.FirstName + ' '... seeker	09-02-2009 09:18 AM Russell Fields	3	590
looking for example using foreach Anyone kind enough to post an example that might use foreach in tsql to list the number of records each table within a database? thanks in advance... Ranny Meier	08-20-2009 08:17 PM Ranny Meier	2	519
Appending ID's from two tables into one table/view Table A has unique student ID's (plus other info) and Table B has unique Instructor ID's (plus other info) I need to combine the ID's from both... TLuebke	08-06-2009 12:34 PM Agile CRM	2	709
In and Like Togehter How can I use In() and Like together. I'm just starting to learn SQl. my Ex. Select username from tablex where username like in( 'j%',... hilltop55	07-30-2009 01:10 PM Russell Fields	2	573
Easy Query Help - Sql Server 2005 - Join Issue I am not a SQL person and have an issue that should be easy for a SQL person to resolve. I am trying to get data from one SQL server and combine it... CQ	07-17-2009 06:47 PM Russell Fields	1	550
if exists statement being ignored I have an if exists do this query (also rewritten as a count) queries below.. that seem to be executing even if the count is 0 or the if exist is not... Tracey	07-17-2009 04:22 PM Tracey	0	460
Using Between and Like together in the where clause I have a SRS report that I am trying to run. The problem is that since it is so large when I run the report in it's entirety, I can't export it out... Wayne	07-02-2009 05:26 PM Hugo Kornelis	1	615
Query that will produce date based on DayNumber, WeekNumber and Ye Hi, I looks like a very easy task, but I couldn't find answer nowhere yet... Using DatePart function I can find out what is day and week number... Dan	06-30-2009 02:01 PM Russell Fields	1	477
RE: Trigger to CLR Stored Procedure Hi Gerhard, Sorry for the delay since I was taking a long vacation in the past 10 days. I reproduced this issue at my side. Based on our internal... Charles Wang [MSFT]	06-17-2009 07:34 AM Charles Wang [MSFT]	0	606
"Greek" the data in my SQL tables I know this is not the specific term, but I have a table of client customers, that I want to use for demonstration purposes, but I don't want to have... JSpence2003	06-08-2009 11:17 AM JSpence2003	0	555
Help for a simple (?) query - part 2 Hi all, sometimes ago I posted this question, but I cannot find the thread anymore: "I'm stuck with a (I think) simple query. A table... Big Passeron	05-22-2009 03:10 PM Hugo Kornelis	1	569
SQL 2005 Querying Question Is it possible to SELECT query from the result of a select query, without creating temp table? and how any reference? example: ie... select * from... Milo	05-18-2009 09:13 AM Russell Fields	1	522

Page 1 of 27

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off