2019-04-15 (first published: 2018-06-01)
1,427 reads
Diagram
Generate scripts for SQL Server Management Studio diagrams
The procedure generates an import script of diagrams.
2019-04-15 (first published: 2017-03-22)
5,211 reads
RE: selecting max of 2 records per account
without knowing what the rest of the structure that the query reference is like, or what kind of data it holds, its a hard ask.I can only assume that lnkey is the primary key field of the table, if so then the below may work.select acct_number , idx, stage from dbo.u_external_requests where category in (5,6,7) […]
2005-05-05
RE: Need suggestions on multiple insertions SP
I would go with SCOPE_IDENTITY(). There is a great example on the differences between these three when you look at BOL for IDENT_CURRENT.
2005-04-27
Query Help ???
MainItemTable (Table1)MainItemsQuantityItem 1100Item 2200Item 3300Item 4400Item 5500SubstituteItemTable (Table2)MainItemsSubstituteItemsQuantityItem 1Substitute Item 1110Item 1Substitute Item 2120Item 2Substitute Item 3210Item 2Substitute Item 4220Item 3Substitute Item 5310This is the way I want to display data. Please help MainItemsSubstituteItemsQuantityItem 1100Item 1Substitute Item 1110Item 1Substitute Item 2120Item 2200Item 2Substitute Item 3210Item 2Substitute Item 4220Item 3300Item 3Substitute Item 5310Item 4400Item 5500
2005-04-08
2 reads
RE: sql tables used by an access application
HI all,I finally fixed the problem. it was that the file that was being written to had the key as an auto number. once I removed that property it was fine. I still don't understand why making the user a member of the database owner role allowed it to work. Juanita
2005-04-07
RE: Stor Proc - Is there a way to extract definition quickly?
Below is a vbscript i wrote to find a variable. If you want allthe procedures, don't enter anything for variable.'This script will give the name of all the procedures wiht occurences of a specifc variable. 'It takes servername, uid, password and variable as the input parameters. If variable is null, it will give you all […]
2005-02-24
RE: shrinkdatabase
Your reindex and maintenance are whats causing the log file to grow so large. As Kathi said, the full backup won't clear anything from the log, so your first log backup after the maintenance is going to be big. If you can afford the space, you should allow the log to stay at the 9gb […]
2005-01-11
RE: Comparison Operator With Local Variable
I do not have Northwind (gotta save that space...), so I plopped your code into Dynamic SQL to see what you produce. Other than the extra paren, this looks excellent. Are you sure CustomerID has these values? DECLARE @Parm varchar(100), @SQL varchar(1000) SET @Parm = 'VINET, TOMSP , VICTE' SET @Parm = '''' + @Parm […]
2005-01-11
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers