|
|
|
Home » Network Pages
A D V E R T I S E M E N T
Resource Directory
Microsoft Sql Server Questions and Answers Page
- importing data from Excel to MssqL 2008 R2
Basically i having try alot of solution but it's still not yet solve my problems.Currently i having ...
- creating a table valued parameter
hello,i am trying to transfer a string of data entries to a stored procedure using the sqldatasource...
- Need help in retrieving the number of records in a nested entity datasource
I do have my nested listview working correctly, but I do not know how to return the number of record...
- Performance drops significantly as input control are inserted
I have a rather complex sqlDataSource query that returns approx.� 4000 records� which are displayed� in...
- Distict column in JOIN table
I have created the Datatable below which feeds a GridView on Page_LoadProtected� Sub� Page_Load(ByVal� ...
- "> "failed to enable constraints" after publishing to server?
Hi All: I'm perplexed by a weird issue I'm having with a strongly typed dataset. I have a tableadapt...
- SQL Statement with DataTable in Where Clause?
I have an SQL Statement like this:SQLReport.SelectCommand = "SELECT [Customer], [ExtSale] FROM [Sale...
- How to get a record from sqldatasource control directly to label1.txt
I have a sqldatasource control that is connected to a database with one record and one field only.Ho...
- ANy good reference for SQL Server Express Learning
I am using Access for my ASP.Net app but it is too slow to get the resultI need to switch to SQL Ser...
- Scalar Variable not declared on creating new SelectCommand
I have a SQLDataSource that displays all the Outfitters from my table when the page is first display...
- How to generate script with data?
How to generate script from a database with its data?I tried it, but it was not generated with data....
- SQL if parametr is null set default
HelloI have a problem with my app, i created a app which manage MySql data base i put DataGrid to ed...
- C# LINQ don't save format datetime to sqlserver
I don't save datetime to sqlServerResult Current in sqlServer 2012-08-24 00:00:00:000But I want resu...
- Connection property has not been initilized error message.
I keep getting an error: ExecuteNonQuery: Connection property has not been initialized.The event han...
- Access users in membership provider created mssql database
I have an MSSQL database created through the membershipprovider thing to use with logins on an ASP.N...
- LinqToEntity query over EntityDataSource
I am trying to use LinqToEntity query over EntityDataSource.The Datasource is :� � � � � � � � � � � Connectio...
- sqlDataSource Class in C# and Connection String
� � � � � � � � � � � � � Hi everybody� � � � � � � � � � � i want to add a connection to my database in my code C# , but ...
- Dynamically set connection string for ObjectDataSource
I am trying to dynamically set the connection string of an ObjectDataSource in a VS 3.5 Web project....
- SQL Server Frequently Asked Questions FAQ
If you have followed a link to this page (i.e. the URL contains "SearchTerms=xxx") please scroll down to see items of i...
- SQL Server Frequently Asked Questions FAQ
If you have followed a link to this page (i.e. the URL contains "SearchTerms=xxx") please scroll down to see items of i...
- SQL Server Frequently Asked Questions FAQ
Excellent Sticky If only the Newbies used it RegardsNThe revolution won't be televised ...
- SQL Server Frequently Asked Questions FAQ
Maybe add a few bits on recursion?...
- SQL Server Frequently Asked Questions FAQ
great wrok Kristenthanks thank you very muchThanks & RegardsSoftware Developerhttp: www.smilemd.com...
- SQL Server Frequently Asked Questions FAQ
when writing an optimized query asuming the results are the same, is it prefereable to use a WHERE or HAVING filter.Exp...
- insert new column that from other table
example i have 3 tablestable1A B Ca1 b1 c1a2 b2 c2a3 b3 c3table2C D Ec1 d1 e1c2 d2 e2c3 d3 e3table3E F Ge1 f1 g1e2 f2 g...
- Pivot Needed
I have the following 3 example tables and data:declare @Employee table (ID int,Name varchar(20))insert into @Employee (...
- Error using Bulk insert
Hi can any one help me with bulk insertBelow is the scenario i have the below codeBULK INSERT CustomerInfo FROM 'C: ...
- Select mixed row
Hi,It is possible to mixed selected row? I have tables ? (it is product recepture for assembly device). DefCREATE TABLE...
- MSSQL Trigger.
Hello All,I really need some help on how to create triggers in MS SQL.Previously we are using MySQL and now we need to ...
- Deploy SQL-Sever Database to a Produtiv-System
Hello,is there a guide or checklist for deploy SQL Server databases (2008 R2) after development and testing to a produc...
- help with case statement
how can I get the statement to show the dates versus the day..the this query has a union so I had to use an alias (ie M...
- ISBN 10-->13
Is there any AS IS script available for converting ISBN10 to ISBN13 into SQL?...
- Query 2 dates values results on same row
Hi,I have to run a query to get the Treshold values for a range of date.Like--> Select Treshold from table1where([Date]...
- SOLVED: LIKE operator ([ ] and or )
This works:SELECT emp_fname, emp_lnameFROM EmployeeORDER BY emp_lname ASC;This does not:SELECT emp_fname, emp_lnameFROM...
- Max Date Query
Ok I am out of my league here and I need some guidance. I have done pretty basic queries and stored procedures but I a...
- Box and Whisker Plot
Hey Everyone . . .I really hate doing this , but I lack the necessary skills to write this from scratch and have not be...
- Upate statement inside of a case statement?
I want to update a table using a update command inside of a case statement. Can this be done, here is a sample of my co...
- use of operator ' ' in sql server
while was reading one of the old posts here, I came across the code below. I could not understand the use of ' ' in thi...
- Help With SQL Query
Hi. I have a staff table and an assignments table. A staff member can have many assignments. I want to query the sta...
- How to develop ETL tool in SQL server
I am a new to SQL server. I want to transfer the data one database to another database. I don't know how to use an ETL ...
- Distinct w Inner Join and other fields?
How do I get just the unique rows (distinct), and more than 1 column field from table, and do an inner join too?EX: I'...
- Unable to connect SQL Server 2008 cluster using IP
Hello, I have installed SQL Server 2008 Enterprise R2 (64bit) in cluster mode on Windows 2008 Server cluster. when ever...
- query optimization for update statement.
Hi,is it any possible way to simplify this below mentioned query?update Table2 set A=1 where leadid in (select leadid ...
- procedure related
SELECT tblplsrptextract1.strSpyIDocType AS SPYDOCTYPE , SUM(CASE WHEN tblplsrptextract1.strusriproduct = 'APP-NEW'...
- Select Data from table
Hi AllI have a table structured which comes by executing the Sql query isjob_id--definition_uid--definition_value12--A-...
- SQL table export to the Excel through sql query
Dear all,Please can anyone provide me the sample for exporting the table into excel throguh sql query.I tried with bcp ...
- How to check values
Sir,I need to check value at 2 mins ..Problem is that I need to check status of user If status of user is same for two ...
- Slow Query
select * from tablewhere Column like '' or Column like ' ' or Column is nullthe table has 23 Lakh rowsi have two prima...
- Decrypt encrypted password
Dears,I have created a asp.net user through asp.net membership form. Here my question that after I crated this user the...
- Order By, Sort Field
Hi, i am new in this forum and also in SQL Database. I have a problem in sorting my record.My query is -> SELECT access...
- question about procedure
dear all;I have a quick question. I have the following procedure belowcreate PROCEDURE test( @p_required INT )asselect...
- Simple LOOP
Hi All - I have the following table:USER_ID QTYjsmith 2rbird 4lsantore 1I need the USER_ID to repeat on multiple lines ...
- Tough Date Query
I am new to sqlserver 2008R2. I am creating stored proc for an SSRS report.I am trying to get a count of red items for...
- difference between '' and "is not null"
Today I have come across a strange situation. I tried a code as below select * from table1where field1 is not nullI wan...
- Help on Sql Query
I am new to writing sql queries. here is my present query select distinct DAY(InvDate) as Date,Location,sum(Inv+St) as ...
- Query help
I am trying to write a select statement to get all requests from a table customerinfo where count of the reqno is great...
- Replace on All Tables - Stored Procedure
Good Afternoon,I am working on a Stored Procedure to replace a string in all tables. When I run a Select statement, I ...
- SP to send email and update record
I set up a nightly job to catch a common error and change a field to the correct value. I also wanted it to email me a...
- Not update the duplicate type
Hi people i have a table like thisCOD TYPE VALUE DEFAULTC001 WWW XXXX 0 C001 EMAIL YYY 0C001 EMAIL ZZZ 0C001 CEL NNN 0C...
- Getting the n-th record of a found set
I have this table that describes the state of production of an item on its way through the different workshops: (this e...
- Can you stop extracting text after first CR?
Is there a way to stop pulling in text from a query after a CR is detected?EX Stuff.Cell: This is a test.onetwothreeI w...
- Dynamic SQL being inserted in weird spot
I have a SQL code where I'm fetching data from 3 cursors and eventually dumping all the data to a .csv file. Now I hav...
- CONVERT
I have the following script lines and I am getting the following error message.."The round function requires 2 to 3 arg...
- SQL View
I need to calculate Expr3=Expr1 Expr 2 in SQL view. I have posted my code below. I am getting an error "The query ca...
- Missing Data
Hi AllCan anyone help me with some code (I?ve been struggling with it all day )I have this table (clusters)NHS_No C...
- getting cpu, memory usage from different servers
Hello all,I need to get the cpu,memory, servername, date of all our servers and put that info into a table everyday.I h...
- help
suppose i have input table like this Emp.No DateE1 10-Jan-2011E1 11-Jan-2011E1 14-Jan-2011E2 10-Jan-2011E2 11-Jan-201...
- Urgent help required with '^' operator
Hi All,I am getting this error when this query is executed:The data types numeric and int are incompatible in the '^' o...
- Get Latest Transaction
How can I pull only latest product made by Cash on every first payment done?1 transaction have unique ID and can purcha...
- Please Advice
Table1ID Code1 A2 B3 C4 D5 E6 F12 L13 M14 N15 O16 P17 Q18 RTable2VALUE1,2,42,5,63,44,6,112,16,118,12,1I have two tables...
- alter n update temptable
Hi, I am facing with this kind of prob where I could not Alter and update temptable in 1 stored procedure(SP). in 1 SP,...
- Rounding down a number
I am writing a query that will show an employee age to determine if they are eligible for a certain benefit. If the emp...
- Simple Problem
Hi All I have the following Orders Table. The ORDER_ID is repeated on multiple lines depending on the amount of col...
- how to update in this scenario?
Hi there,I have a table which has a field 'Code'. Code has text of 'http: ...' Now I want to replace http: to https...
- query
1) I need a query which result in the output of second maximum salary in an employee table.2) in which year the maximum...
- Query doubt
On the 13 th line of this query i need to get results of fk_statusid=3 and 5. Here below am able to get only 3.... how ...
- Cardinality
HI All,I have created a few tables in a database. But how do I cardinality between the tables.For example like 1:N,M:M ...
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
| |
|
Add to Favorites
Make Home Page
