We have migrated an old database system from SQL Server 2000 to 2008. Queries that worked on the old server no longer work on the new one when executed from a client machine but the same queri...
If I have a VarChar(max) populated with only five characters will this take up the same amount of space in the buffer pool as VarChar(5).
If I made this change would it improve the performa...
I am trying to add "Terms_Net_Days" onto the "desired_recv_date". It will either be a 30 day or a 45 day. This will cerate the field "Payment_Due"
Any suggestions?
Thanks
I have a a table where the PK column size needs to be increased. I've tried disabling constraints etc. with no luck.
See my table create script in the code section.
'--------------------...
Hi,
I am using this SQL to calculate the UNIX Tmestamp, that is, the number of seconds since 1970-01-01 00:00:
The Timestamp it returns is exactly 5 hours slow. The server clock and time-...
I am tring to get the Month Name as 'MMM' and sort in the asending order from this Procedure ... But it return me the error below.
Error Message :
ORDER BY items must appear in the selec...
I have a VB program that pulls data from a sql server that I need to export out to an excel file. The unique thing is the table is always building and I only need to export new records. The ...
Hi all
I have a table named "Nodes" with the following columns: "companyID", "parentID"
In this table a "Parent/Child" relationship is kept, in order to know which companies belong to w...
The following SQL shows error:
Incorrect syntax near the keyword 'like'.
How should I write it?
Hi, the following query works to get list grouped by A and the MIN of (C),
but I wish to add the Date to results that correspond with the MIN of C, do
I need an inner join somewhere to do th...
I am grouping a report by week (ww) but a number is displayed, 1-52. Is there a way to get this to display as a date range? ex - 9-6-09 - 9-12-09 is equal to week 37.
Thanks
I used Glassfish v2 for my web server ,I use MS SQL for database.In Glassfish I configure connection pool to connect to MS SQL server.When I run my application ,It has a bug "Local transaction...
I've tried this a few ways and cannot figure it out. Any help would be appreciated.
SELECT COUNT(etf_claims.claim_status = 'Open') AS p_open, COUNT(etf_claims.claim_status = 'Auto') AS p_a...
I have a HUGE XML file which I want to load into Sql Server 2005 Table. I have the xsd file for this as well.
I have tried SSIS, and it works for smaller files (using Data Transfrom > XML S...
What is causing the contents of the Report Viewer 2008's Export list to vary between host machines? In one case it is only showing 3 formats and in another it is showing 7 formats. See attac...
Hi
There are 2 queries below.
First query shows:
1
2
3
4
5
6
Second query shows
5
3
1
How can I write one query to show
5
3
1
------------
2
4
6
And, how to show...
I use the query below to return monthly totals from a running total SQL table. The Table is updated every 15min and is always increasing.
The query below will return the month data only whe...
I am selecting data from a link server.
it works ok if I do not have any error handling around it. see code below
this is the error message: OLE DB provider "SQLNCLI" for linked server...
I have a db that is 13 gb and I suspect I have some tables that are really large...
How do I find them...and shrink them?
I already tried shringing the db..see attached snippets
Good day experts !!
I have a quick question regarding using the DatePart (dow) option as a bit mask for selecting
date values. I am basing this off of SQLDMO_WEEKDAY_TYPE constants foun...
Hi
I use MSSQL 2005
operator table has id, name, age fields
operator_session table has id, name fields
The following query can display id, name and age (not in operator_session table...
is ther a efficient way to add the name of month in JAN FEB MAR format to column called MYMONTH
example data
MYMONTH
Jan
Feb
Mar
Apr
etc...
i tried the following code but I get ...
I have a table where I need to count the number of entries in a field, calculate the total and report in a table.
Basically its a school behavior database and I need to count the number of ...
Hi, I need to query the table below and return a forecast reference that has
- the highest date in the previous month
- Starts with FPH
- Is not FPHLIVE
So assuming it is September, I wo...
i have a table that i would like to know the missing numbers or a range of missing numbers if more than 1 was skipped
i.e
4
7
12-14
20
this sql gives me my list of numbers
Se...
