Topics
Started by
Posts
Last post
I need to move data from Excel spreadsheet into table. 2 columns in spreadsheet need to be con…
3 replies
how do i auto increment number starting from a particular range like 600 then next should be…
5 replies
Hi folks, I am migrating from Access to SQL Server. Some views (that query other views) are slower…
16 replies
I have been asked to write some SQL (using Reporting Services) for the value of sales between a dat…
2 replies
Just thought of this... which of these 2 statements are faster? SELECT * FROM Table1 where Val IS I…
20 replies
I have a table of events, each with a start and finish date. I'd like to write a query which will r…
10 replies
does any one have sql code to check the sql server uptime that returns a string with yrs, months, d…
4 replies
Is there a way that I can use, say, "select top 10 * from Table1", or "set rowcount 10 select * fro…
19 replies
Hi, I have data that has account balances that repeat like this: ID DenialDate DeniedCharg…
11 replies
Hi All, I have a strange problem. A stored procedure running some quite complex sql slowed do…
2 replies
I would like to identify all of the Fridays in a year and then group data into these weeks. Any sug…
1 replies
I have a problem tunning a query which self join itself like; select aud.inv_id as change_value_1, …
6 replies
Could someone give me some help on inserting the field PRContactAssoc.Role with this script? (Error…
3 replies
Is there anyway of changing the Incremental values in Identity column by using a script like Alter …
4 replies
Hi All, I have a table with the following fields: TransactionId, AssetType, AssetDetails, Order. Pr…
8 replies
Viewing 15 topics - 11,011 through 11,025 (of 17,082 total)
You must be logged in to create new topics.