[mssql] Forum Topics

I have a stored procedure. This proc returns some data that needs to be put in an excel format. Is it possible to create a excel file to have the result of a select statement from the database? please help me out. Thanks

I'm using this to match a phoneNumber that is 10 characters in lenth. Is there a cleaner way to write this? [CODE]select * from a where TelephoneNummber not like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'[/CODE]

Hi I have a MS SQL db script, I have the same temp table declared more than once. I keep getting this error: There is already an object named ????(question marks are representative of table name) in the database. the following resembles what my script looks like. [CODE] IF OBJECT_ID('tempdb..#table123') …

can any one tell me to find out the list of databases that have “.ldf” size greater than “.mdf”.

Hello, I'm using MySQL for a database containing 1 table with 10 columns. The point is to get a view of a few columns and use it in a web application So, I need 2 columns from this table - Pad(varchar) and Sequence(integer), then I create 8 views like this: …

[CODE]UPDATE table2 SET table2col1 = table1.col1, table2col2 = table1.col2, ... FROM table1, table2 WHERE table1.memberid = table2.memberid[/CODE] will the above query help me to update fields from one table to fields in another table base on a common id between the two tables?

Hi I have a issue that my application in currenlty doing number validation with an issue. I have a query that checks number is stored procedures but need more checks. [-d0-9] and checking that the lenth is 10 characters, all that is working as it should. The issue I'm having …

Hi all. I am trying to create a search that displays 3 columns. Analysis, Amount, Amount of Positiv results I have nailed down Analysis, Amount, but have problems displaying Pos. result. [CODE] SELECT DISTINCT SP.ANALYSIS AS Analysis,COUNT(SP.ANALYSIS) AS Amount FROM SAMPLE S INNER JOIN SAMPLE_PARTS SP ON SP.SAMPLEID = S.SAMPLEID …

Hi, everyone... I have a question about sql .. Question: Customer | jan-april | may - august| september - december A |quantity | | B | | | C | | | How to use the SELECT command to retrieve data and the output is show like above. please give …

Hello, I need to connect to a DSN on a remote computer. I have found a lot of a lot of info on how to connect to a remote database from a local DSN, but nothing on connecting to a remote DSN. I am using asp.net, but help on solving …

Hey, I new in MS SQL I got one question don,t know how to solve..? Display code, name, place , total contract quantity for top 10 buyers how to write in MS SQL/...?

Hi, can anybody, please help me out. [CODE][B]select * from log where id <='%07%' [/B][/CODE] Am facing the syntax error, what is the actual query? my id look like this: 1.mtg10kl 2.mtg07kl 3.mtg06kl 4.mtg09kl I need the output this: 1.mtg07kl 2.mtg06kl please help me out .thanks in advance

I'm sorry if this should have been posted in the c# forums..... I have created a database for my website and am using MS SQL. This database will need to be accessed by users on the site itself, and from a .NET application. I am comfortable using MS SQL through …

Dear Sir, I want to silently instal SQLEXPRESS 2005 it is not working.... Please reply...becs i want to install SQLEXPRESS 2005 through my application... The command line used by me is "START /wait sqlexpr.exe /QS /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /ERRORREPORTING=0 /FEATURES=SQLEngine /INSTANCENAME=MSSQLSERVER /BROWSERSVCSTARTUPTYPE=Disabled /SECURITYMODE=SQL /SAPWD=123 /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSVCSTARTUPTYPE=Automatic /TCPENABLED=1 /SQLSYSADMINACCOUNTS=".\User" ".\Administrator" /AGTSVCACCOUNT="NT …

hi, i have a question in C#.net report viewer. i want to create a report which will take a user input and generate a report. what i want is get the month from the user input and get it as a parameter for the sql query go get the result. …

I not sure how to do this.Could anyone can help me...? question: Display all buyer (code, name) who has average purchase each year for more than 100000 for past 10 years here is my query: [CODE]SELECT b.CODE, b.NAME from ( SELECT BUYER, AVG(TOTAL) AS total FROM SMF WHERE TOTAL > …

Hi, Am created a login and an user to access sql server instance and the database. [CODE]Creating Login: create login xxx with password='secret'; Creating User: use testdb; create user yyy for login loginname; [/CODE] And then i login with this login name(xxx) and also i can able to access the …

Hi, I have a table QuestionAsked which contains a column DateofAsking. Now what i need is to extract each date value and check whether the difference between that day and the current day is 14 or not. If yes than i have to update a particular column in that table.I …

I am attempting to pull a single record with the most recent affective date. However, I am getting two records with effective dates of 04/01/2010 and 12/01/2009. Can someone please tell me how to pull only the record with an effective date of 04/01/2010? Thanks for your help. [CODE] select …

Good Day All I have a File Format Defined like this [QUOTE]9.0 4 1 SQLCHAR 0 100 "," 0 ExtraField "" 2 SQLCHAR 0 100 "," 1 Descr SQL_Latin1_General_CP1_CI_AS 3 SQLCHAR 0 100 "," 2 ABREV SQL_Latin1_General_CP1_CI_AS [/QUOTE] and i use it like this [CODE]BULK INSERT dbo.TBL_CMPS FROM 'C:\\UNISA_IMPORT\\Final_Import\\Campuses.csv' WITH …

hi, i am using sm sql express 2008 and this does not have the backup feature. so i have to create a application to back up the database everyday automatically, does anybody know a way to do it,please reply thank you.

Hi expert, When i try this script i got 2 esn number with different shipdate and supplierid. were us it should be the latest shipdate should be obtain. Any Idea guys. thanks. [CODE] TABLE1 ESN 123 TABLE2 ESN--SupplierID--Shipdate 123--40----------2011-04-27 123--14----------2011-07-02 Select vp.esn, us.supplierid, us.shipdate --(Select Max(shipdate) from TABLE2 where vp.esn …

VS 2005 I just started to realized the power of SSIS packages meaning I am very new. Anyways I built a package that pulls from one of my stored procs and creates a flat file out of it and then sends to an FTP folder Okay now the problem is …

We use a single database in SQL Server 2005 and the size is around 190 GB. We plan to spilt the database in following methods; 1. single instance multiple database without synonyms 2. single instance multiple database with synonyms 3. multiple instance multiple database Need inputs on the below queries: …

Hi there, Im working on a web database application and Im encountering problems to connect the database and the ASP.net page. The database is being detected but not the tables inside the database. Could anybody help me?

Guys, I have 2 tables. My objective is to get the information from Table1 and place it to table2. the 2 tables have the same Itemnumber and DefectCode. How could make this in correct scripts cause when i make the script it triple the records. [CODE] TABLE1 ItemNumber---------Price---PO-------Code-Qty P300-1710-DROID-U--302.05--9100962--506--1 P300-1710-DROID-U--302.05--9100962--553--4 …

how to create stored procedure for altering multiple coulmns , how to create stored for creating dynamic table and add multiple columns to created table

hi, i have an application that feeds data into a table of a database - table name is XTABLE716C6DC3. now i need a stored procedure that takes and calculates data from that dable anytime the table is changed and store the results in a certain format into a new table …

hi everyone they said in relational database there is no "last" concept.. and the only way to retrieve the last data entered in database is by IDENTITY and sone says TIMESTAMP... which one i would prefer to use?

can anyone tell me how to insert { in sql. Eg. insert into dm_dbo.prsn_ps_epm(product_id,imprint_name) values('123456','nisheeth{jain');