Topics
Started by
Posts
Last post
I need to create a report about the SQL Agent Jobs. The information I need is the Job name, Status …
2 replies
Hi, Table Name - EnergyMeter Filed Name - Meter_Id Total Records - 6 using stored procedure - how c…
2 replies
Hi, How can i convert a binary to varchar datatype or a varchar to binary data type.
1 replies
I'm after a way to strip out the date from a smalldatetime column, but still store it as smalldatet…
2 replies
Hi Team, Using below script Loading data into a table but 1st time data was loading perfectly when …
1 replies
I have a table in my sql server 2005 database where I need to replace all the values in one particu…
7 replies
I need to return NULL values as output, if there is no matching records for a select query. Any ide…
2 replies
The attached is a brief example of a file extracted(Top 5.xls). The data definition is: 1. Key - Id…
9 replies
The database I'm working with is an order database. It stores order status in a history table whose…
4 replies
Some records in this field have len = 22000. When I run the query (Select Summary From MyTbl Where …
5 replies
I am using a Database on a Server that I don't have much access through (Its held via an external c…
4 replies
When pulling data, I need to summarize totals by Week of the current month. e.g. if the 1st of the …
5 replies
I have a query when run will return an incorrect value for the "Gross Profit" field. This is happe…
1 replies
I have 3 tables. One is SiteSchool, one is School, the other is Site. The 3 tables are as below, my…
6 replies
Hi Guys I have the following code EXEC sp_msforeachdb @command1="use ? exec sp_spaceused" Is there…
37 replies
Viewing 15 topics - 7,276 through 7,290 (of 10,647 total)
You must be logged in to create new topics.